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

Call Center Indodax
Hubungi Call Center INDODAX melalui +62822225789 WA atau email support@indodax.com.
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…