Loading
Ongoing maintenance for Salesforce HelpRead More
Feature degradation | Gmail Email delivery failureRead More
Extend Salesforce with Clicks, Not Code
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
            Tips for Working with Numbers in Formulas

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            Tips for Working with Numbers in Formulas

            Get tips for using number fields in your formulas. Learn how to work with percent fields using decimal values and how to reference auto-number fields as text. Plus, find guidance on mixing numbers with percentages and currencies, and understanding output limits and rounding behavior.

            Required Editions

            Available in: both Salesforce Classic and Lightning Experience
            Available in: All Editions
            • Use the decimal version of a percent when working with percent fields in formulas. For example, IF(Probability =1...) for 100% probability or IF(Probability =0.9...) for 90% probability.
            • Reference auto-number fields as text fields in formulas.
            • The output of your formula must be less than 19 digits.
            • Formulas can contain a mix of numbers, percents, and currencies as in this example: AnnualRevenue / NumberOfEmployees.
            • Salesforce uses the round half up tie-breaking rule for numbers in formula fields. For example, 12.345 becomes 12.35 and −12.345 becomes −12.35.

            See Also

             
            Loading
            Salesforce Help | Article