---
schema_version: "1"
id: 18765256b8000b0d32471b16896f46dd26c6f587c264facf571e8355b78dd42f
title: Numeric Functions for Formula Fields
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_data_prep_recipe_formula_field_numericfunctions.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: dca133195f8d86b870249db9a8877fd9b9acf9422fc47ce70a8ca377cb1b77f2
description: 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.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in Salesforce Classic and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</td></tr></tbody></table>

![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 recipe, see [Numeric Operators and Functions for Formulas](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_numericfunctions.htm&release=264.0.0&type=5 "In CRM Analytics, use numeric functions to calculate values from numbers in your recipe. For example, you can round, truncate, and determine the absolute value of a number. The arguments for numeric functions can be number values or columns.").

- **[abs Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_abs.htm&release=264.0.0&type=5)**  
    Calculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.
- **[ceil Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_ceil.htm&release=264.0.0&type=5)**  
    Rounds a number up to the nearest integer.
- **[exp Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_exp.htm&release=264.0.0&type=5)**  
    Returns a value for e raised to the power of a number you specify.
- **[floor Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_floor.htm&release=264.0.0&type=5)**  
    Returns a number rounded down to the nearest integer.
- **[log Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_log.htm&release=264.0.0&type=5)**  
    Returns the logarithm of a number in the base you specify.
- **[power Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_power.htm&release=264.0.0&type=5)**  
    Raises a number to the power of another number.
- **[round Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_round.htm&release=264.0.0&type=5)**  
    Returns the nearest number to a number you specify, constraining the new number by a specified number of digits.
- **[sqrt Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_sqrt.htm&release=264.0.0&type=5)**  
    Returns the positive square root of a given number.
- **[trunc Function](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_formula_field_numericfunctions_trunc.htm&release=264.0.0&type=5)**  
    Truncates a number to an integer.