Loading
Service Degradation: Knowledge Search and Agent ResponsesRead 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
            + (Add)

            You are here:

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

            + (Add)

            Calculates the sum of two values.

            Use

            value1 + value2 and replace each value with merge fields, expressions, or other numeric values.

            Note
            Note If the values are text, the + concatenates.
            Formula Field Example
            Formula Field Example

            Amount + Maint_Amount__c + Services_Amount__c

            This formula calculates the sum of the product Amount, maintenance amount, and services fees. Maint amount and Service Fees are custom currency fields.

            Report Example
            Report Example

            EMAIL_OPT_OUT:SUM + DO_NOT_CALL:SUM calculates all Email Opt Out fields plus all Do Not Call fields on the leads in your report. This formula is a number data type that returns a positive integer.

            Validation Rule Example
            Validation Rule Example

            Let’s say you have a custom object that allows users to track the total number of hours worked in a week. Use the following example to ensure that users can’t save a time card record with more than 40 hours in a work week.

            Monday_Hours__c + 
Tuesday_Hours__c + 
Wednesday_Hours__c + 
Thursday_Hours__c + 
Friday_Hours__c > 40

            Use a formula like this one in a validation rule to display the following error message when the total number of hours entered for each work day is greater than 40: “Your total hours can’t exceed 40.” This example requires five custom fields on your custom object, one for each day of work.

             
            Loading
            Salesforce Help | Article