Numeric Functions for Formula Fields

Use numeric functions to calculate new values from measures in your recipe. For example, you can round, truncate, and determine the absolute value of a number. The arguments in each function can be numbers or measure columns.

Required Editions

Available in Salesforce Classic and Lightning Experience.

Available with CRM Analytics, which is available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in Developer Edition.

Note To get a list of numeric functions for a Data Prep recipe, see Numeric Operators and Functions for Formulas.

• abs Function
  Calculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.
• ceil Function
  Rounds a number up to the nearest integer.
• exp Function
  Returns a value for e raised to the power of a number you specify.
• floor Function
  Returns a number rounded down to the nearest integer.
• log Function
  Returns the logarithm of a number in the base you specify.
• power Function
  Raises a number to the power of another number.
• round Function
  Returns the nearest number to a number you specify, constraining the new number by a specified number of digits.
• sqrt Function
  Returns the positive square root of a given number.
• trunc Function
  Truncates a number to an integer.