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
0
Answers
-
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 excel1 -
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.
2
