Downloadable User Guides
Tips for Working with Number Formula Fields | Salesforce
Tips for Working with Number Formula Fields
Available in: both Salesforce Classic and Lightning ExperienceAvailable 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.34.
See Also:Tips for Building Formulas
One Market St.
San Francisco, CA, 94105
If you still can't find what you're looking for try searching H&T.
Powered by the Salesforce Communities platform. Learn More ›