Percentage Rounding Issue

Contributor

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,
Tags (2)
Message 1 of 5
4 REPLIES 4
New Contributor

Re: Percentage Rounding Issue

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

Message 2 of 5
Highlighted
Contributor

Re: Percentage Rounding Issue

Yeah, I tried that (see attached) but still no good unfortunately.
Message 3 of 5
Certified Master Anaplanner

Re: Percentage Rounding Issue

Hi @Ceri ,

 

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

 

Regards,

Niranth

Message 4 of 5
Certified Master Anaplanner

Re: Percentage Rounding Issue

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

Message 5 of 5