Incorrect % line item summary

Hello Everyone,

I've a list with 10 members where each member has a value of 10%. The summary for this line item shows 0.999.. instead of 1 in the backend. When I'm comparing the summary with 1 it gives me incorrect value. Does anyone know the reason for this? The summary is correct as 1 when the value entered is 50% for 2 list items. So I'm unable to figure out the reason for this. To resolve this I'd converted the % line item to number and the number again to % to compare it with 1.

Thank You.

Accepted answers

All comments

Are you sure the other 10% members are really 10% or is that what you see. To figure this out, do the same exercise you did to validate the 100% and the 99.99% for the other 10 members.

JaredDolich

@nidhijhandai

Where are you seeing the 99.99 percentage? Can you expand the line item to 2-decimal places?

nidhijhandai

Hi @rob_marshall

The other 10% members are actually 10%. Please see attached snap:

nidhijhandai

Hello @JaredDolich

Here is where I see the 99.99%. I've expanded the line item to 2 decimal places. See attached snap:

JaredDolich

@nidhijhandai hahaha! Well, well, well. I tested this myself and I get the same result as you! I never noticed this - but 7 years ago I did an implementation that required precision 12 decimal places and it drove me crazy that I couldn't get it to work. I wonder if this is something that has been around a long time?

Anyway, not much I can do. I tried messing around with the precision but to no avail. I tried creating another line item that rounds to the nearest two decimal places and that didn't work either. Maybe @rob_marshall has connections at Anaplan that can explain why this is happening. Only other option you have is to log a support issue.

Sorry this is happening but glad to know there's a precision issue.

rob_marshall

@nidhijhandai

Yep, I did the same thing as @JaredDolich and found after 7 inputs (in my case), it blew up

nidhijhandai

Hello @JaredDolich & @rob_marshall

I tried another method where in I created a new line item with summary as formula. In that new line item (Test Summary from below snap) I'm comparing the 100% from Value with 1 and it gives correct result. This shows that in the backend Anaplan may have precision issue but it gives the correct math in below example. See below snap for the same, weird though

JaredDolich

@nidhijhandai bizarre behavior. I'm sure the development team will be interested in seeing that. Hope you can get their attention, or at least have it documented as a known issue with the support team.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
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…