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,


  • 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,


  • 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. 



    Vignesh M

  • Hi @CommunityMember83188 ,


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