Building formulas

Custom formula fields require additional settings as specified by the Salesforce CRM application, which are carried out using the following actions and steps:

  1. Create the Formula field.
  2. Choose the data type for the field, based on the output of the calculation.
  3. Enter the number of decimal places for currency, number, or percent data types.

    Note

    The setting for the number of decimal places is ignored for currency fields in multi-currency organizations. Instead, the decimal places for your currency setting apply. 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.

  4. Click on Next to display the formula creation screen.

Get Salesforce CRM - The Definitive Admin Handbook - Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial