---
schema_version: "1"
id: 52795fa5dbd9a4dca3d7ef4345598596e759b5e5942fbbd775715576f2aebda6
title: Numeric Operators and Functions for Unconverted Formulas
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_numericfunctions_simple.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_numericfunctions_simple.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2fbb3bda78a96cff06a5588df4f32babeb4cb17030db8dcb6dfc6ac8b2381bef
description: 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.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note To get a list of numeric functions for a Data Prep Classic recipe, see [Numeric Functions for Formula Fields](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions.htm&release=264.0.0&type=5 "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.").

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.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:22.98850574712644%">
        <col style="width:32.41379310344827%">
        <col style="width:44.59770114942529%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23810e134">Numeric Function</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23810e137">Description</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23810e140">Syntax</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>abs</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Calculates the absolute value of a number. The absolute value of a number is the
            number without its positive or negative sign.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>abs(<samp class="parmname">number</samp>)</code>
            </p>
            <p><samp class="parmname">number</samp> is a
              number or measure column that you want to determine the absolute value
              of.</p>
            <p style="margin-bottom:0;">Example: <code>abs([Amount])</code></p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>ceil</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Rounds a number up to the nearest integer.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>ceil(<samp class="parmname">number</samp>)</code>
            </p>
            <p style="margin-bottom:0;"><samp class="parmname">number</samp> is a
              number or measure column that you want to round up to the nearest
              integer.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>exp</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Returns a value of e raised to the exponent that you specify.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>exp(<samp class="parmname">number</samp>)</code>
            </p>
            <p style="margin-bottom:0;"><samp class="parmname">number</samp> is a
              number or measure column to which you want to raise e.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>floor</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Returns a number rounded down to the nearest integer.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>floor(<samp class="parmname">number</samp>)</code>
            </p>
            <p style="margin-bottom:0;"><samp class="parmname">number</samp> is a
              number or measure column that you want to round down to the nearest
              integer.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>log</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Returns the logarithm of the number in the base that you specify.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>log(<samp class="parmname">base</samp>,<samp class="parmname">number</samp>)</code>
            </p>
            <p><samp class="parmname">base</samp>
              is a number or measure column used as the base of the
              logarithm.</p>
            <p style="margin-bottom:0;"><samp class="parmname">number</samp> is a number or measure column that
              you want to take the logarithm of.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>power</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Raises a number to the power of another number.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>power(<samp class="parmname">number</samp>,<samp class="parmname">power</samp>)</code>
            </p>
            <p><samp class="parmname">number</samp>
              is a number or measure column that you want to raise to the specified
              power.</p>
            <p style="margin-bottom:0;"><samp class="parmname">power</samp> is a number or measure column that is the
              power that you want to raise the specified number to.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>round</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Returns the nearest number to a number you specify, constraining the new number
            by a specified number of digits.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>round(<samp class="parmname">number</samp>,<samp class="parmname">numberOfDigits</samp>)</code>
            </p>
            <p><samp class="parmname">number</samp>
              is a number or measure column that you want to
              round.</p>
            <p style="margin-bottom:0;"><samp class="parmname">numberOfDigits</samp> is a number or measure column
              that specifies the number of digits to round the specified number to.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>sqrt</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Returns the positive square root of a given number.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>sqrt(<samp class="parmname">number</samp>)</code>
            </p>
            <p style="margin-bottom:0;"><samp class="parmname">number</samp> is a
              number or measure column that you want to find the square root of.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Numeric Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e134 ">
            <code>trunc</code>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e137 ">Truncates a number to an integer.</td>

          <td data-label="Syntax" class="slds-cell-wrap" style="vertical-align:top;" headers="d23810e140 ">
            <p>
              <code>trunc(<samp class="parmname">number</samp>)</code>
            </p>
            <p style="margin-bottom:0;"><samp class="parmname">number</samp> is a
              number or measure column that you want to truncate to an integer. </p>
          </td>

        </tr>
      </tbody>
    </table>