Print this page

ANALYTICS CLOUD: Numeric Value Range

Knowledge Article Number 000213628
Description

Analytics Cloud internally stores numeric values as long values. For example, it stores the number “3,200.99” with a scale of  “2” as “320099”. The user interface converts the stored value back to decimal notation to display the number as “3200.99.”

 

The maximum numeric value that can be stored in Analytics Cloud is 36,028,797,018,963,967 and the minimum numeric value is -36,028,797,018,963,968.

 

Warning: You may experience unexpected results if the value is not within this range. For example, if you try to load the value 3.7E-16 with a scale of 16 into a dataset, Analytics Cloud tries to store the value as 37000000000000000. However, because this value exceeds the maximum, Analytics Cloud fails to load the entire record. In addition, if you perform a query that aggregates measures—like sum or group by—and the resulting value exceeds the maximum, the value overflows and Analytics Cloud returns an incorrect result.

 
Resolution This behavior is known, but we are working to alleviate this limitation soon.




promote demote