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,

Rounding_issue_49756.png

Accepted answers

All comments

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

Yeah, I tried that (see attached) but still no good unfortunately.

Rounding_issue_2_49758.png

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

Hi @CommunityMember83188 ,

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

Regards,

Niranth

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…