Loading
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Numeric Operators and Functions for Unconverted Formulas

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Numeric Operators and Functions for Unconverted Formulas

            Use numeric functions to calculate values from measures in your recipe. For example, you can round, truncate, and determine the absolute value of a number. The arguments for numeric functions can be numbers or measure columns. If your recipe was upgraded to Data Prep, but your recipe doesn’t convert, this topic is for your unconverted recipe.

            Note
            Note To get a list of numeric functions for a Data Prep Classic recipe, see Numeric Functions for Formula Fields.

            When entering a formula, column names must be enclosed in square brackets. Also, use the API name of the column in the expression, not the label. For example, you can enter the following expression. 

            round([Total_Amount]/[Unit_Price], 2)

            You can use these math operators.

            Operator Description
            + Calculates the sum of two values.
            - Calculates the difference between two values.
            * Multiplies the two values.
            / Divides the first value by the second.
            () Specifies that the expressions within the parentheses are evaluated first. All other expressions are evaluated using standard operator precedence.

            You can also use these numeric functions in an expression.

            Numeric Function Description Syntax
            abs Calculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.

            abs(number)

            number is a number or measure column that you want to determine the absolute value of.

            Example: abs([Amount])
            ceil Rounds a number up to the nearest integer.

            ceil(number)

            number is a number or measure column that you want to round up to the nearest integer.
            exp Returns a value of e raised to the exponent that you specify.

            exp(number)

            number is a number or measure column to which you want to raise e.
            floor Returns a number rounded down to the nearest integer.

            floor(number)

            number is a number or measure column that you want to round down to the nearest integer.
            log Returns the logarithm of the number in the base that you specify.

            log(base,number)

            base is a number or measure column used as the base of the logarithm.

            number is a number or measure column that you want to take the logarithm of.
            power Raises a number to the power of another number.

            power(number,power)

            number is a number or measure column that you want to raise to the specified power.

            power is a number or measure column that is the power that you want to raise the specified number to.
            round Returns the nearest number to a number you specify, constraining the new number by a specified number of digits.

            round(number,numberOfDigits)

            number is a number or measure column that you want to round.

            numberOfDigits is a number or measure column that specifies the number of digits to round the specified number to.
            sqrt Returns the positive square root of a given number.

            sqrt(number)

            number is a number or measure column that you want to find the square root of.
            trunc Truncates a number to an integer.

            trunc(number)

            number is a number or measure column that you want to truncate to an integer.

             
            Loading
            Salesforce Help | Article