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

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 excel
  • 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.