CRM Analytics internally stores numeric values in datasets as long values. For example, CRM Analytics 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.
- Range Limits for Numeric Values
The maximum numeric value that can be stored in a dataset is 576,460,752,303,423,488 and the minimum numeric value is -576,460,752,303,423,488. - Considerations for Numeric Values
Confirm that numeric values in a column are uniform in granularity and units. Inconsistencies can occur within a data source and after merging data from multiple data sources. - Handle Null Numeric Values
When you create or update a dataset through your dataflow, recipe, or a CSV upload, for example, CRM Analytics replaces blank numeric values with the specified default value. When no default value is specified, CRM Analytics replaces blanks in numeric columns with 0 or null based on whether you enable null measure handling.