Percentage Rounding Issue

CommunityMember83188
CommunityMember83188
in Modeling
I have a module where users will be loading percentages - to 3 decimal places - against markets on a monthly basis. When Anaplan is summing the amounts inputted there's an issue with the calculation it's doing - see attached file, where I would expect the FY result to be 0.6 not 0.60000000000001 Would anyone have an idea why this is happening and what I can do to correct it? Thanks,
Tagged:

Answers

  • MattDennis
    MattDennis

    Hi Ceri,

     

    Could you add a line item into the same module with the formula 'ROUND(Plan, 3)' and see if that resolves the issue? I am assuming the markets are the row values and the line item in the picture is called Plan.

     

    Kind regards,

    Matt

  • CommunityMember83188
    CommunityMember83188
    Yeah, I tried that (see attached) but still no good unfortunately.
  • VIGNESH.M
    VIGNESH.M

    Hi,

     

    It might be from the CSV file.

    Please change the data format in your CSV to 3 decimal and load it. 

     

    Thanks,

    Vignesh M

  • Niranth
    Niranth

    Hi @CommunityMember83188 ,

     

    Try changing the summary(In blue print view) to 'Formula'. I should solve your issue.

     

    Regards,

    Niranth

Categories