Percentage Rounding Issue

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

  • 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

  • Yeah, I tried that (see attached) but still no good unfortunately.
  • 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

  • Hi @CommunityMember83188 ,

     

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

     

    Regards,

    Niranth