Handle Numeric Values

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 36,028,797,018,963,967 and the minimum numeric value is -36,028,797,018,963,968.
• 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.