Decimal Places for a Number Formatted Line Item

[carlossyquia]

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

[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.