Loading
Prepare for Email to Become the Default Login ExperienceRead More
Ongoing maintenance for Salesforce HelpRead More
Extend Salesforce with Clicks, Not Code
+ (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