topic Re: Decimal Places for a Number Formatted Line Item in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Decimal-Places-for-a-Number-Formatted-Line-Item/m-p/97173#M22285
not sure the maximum.<BR />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))<BR />Do that for what's after the common, you can FIND it with FIND, exactly like in excelTue, 09 Feb 2021 08:30:22 GMTnathan_rudman2021-02-09T08:30:22ZDecimal Places for a Number Formatted Line Item
https://community.anaplan.com/t5/Anaplan-Platform/Decimal-Places-for-a-Number-Formatted-Line-Item/m-p/97161#M22278
<P>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</P>Tue, 09 Feb 2021 04:53:32 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Decimal-Places-for-a-Number-Formatted-Line-Item/m-p/97161#M22278CommunityMember1142652021-02-09T04:53:32ZRe: Decimal Places for a Number Formatted Line Item
https://community.anaplan.com/t5/Anaplan-Platform/Decimal-Places-for-a-Number-Formatted-Line-Item/m-p/97173#M22285
not sure the maximum.<BR />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))<BR />Do that for what's after the common, you can FIND it with FIND, exactly like in excelTue, 09 Feb 2021 08:30:22 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Decimal-Places-for-a-Number-Formatted-Line-Item/m-p/97173#M22285nathan_rudman2021-02-09T08:30:22ZRe: Decimal Places for a Number Formatted Line Item
https://community.anaplan.com/t5/Anaplan-Platform/Decimal-Places-for-a-Number-Formatted-Line-Item/m-p/97191#M22288
<P>They are held in Anaplan using <A href="https://en.wikipedia.org/wiki/Double-precision_floating-point_format" target="_blank" rel="noopener">IEEE754 double-precision binary floating-point format</A> 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.</P>Tue, 09 Feb 2021 12:10:34 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Decimal-Places-for-a-Number-Formatted-Line-Item/m-p/97191#M22288ben_speight2021-02-09T12:10:34Z