Decimal Places for a Number Formatted Line Item

What is the maximum number of decimal places for a number formatted line item? Is there a way to check which cell for a given line item has the most decimal places? Need to know for an export into a datalake / warehouse for storage

Accepted answers

All comments

nathan_rudman

not sure the maximum.
to determine how many decimals a number has, best ay is to have a text line item, bring the number value and count it LEN(TEXT(item))
Do that for what's after the common, you can FIND it with FIND, exactly like in excel

ben_speight

They are held in Anaplan using IEEE754 double-precision binary floating-point format which gives from 15 to 17 significant decimal digits precision and up to a three-digit signed decimal exponent. Many other products also support this natively as modern hardware works with it efficiently.

Quick Links

🔥 Popular Content
🚀 My Activity
⭐️ Recent Discussions
🙋🏻‍♂️ Unanswered
👥 Groups
⚙️ About Community

Can you help?

Unanswered questions

Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.