Create a Roll-Up Summary Field

Create a Summary Field

Next, you create a field on the Travel Approval object that automatically sums up the total amount of expenses from the related Expense Items. Salesforce has a field called a roll-up summary field that provides this functionality.

1. From the Travel Approval object, select Fields & Relationships.
   
2. Click New.
   
3. Select the Roll-Up Summary data type.
   
4. Click Next.
   
5. Enter the following values for the field details:
   

1. Field Label: Total Expenses
   
2. Field Name: Total_Expenses (this automatically gets set when you tab out of the Field Label field)
   
   

6. Click Next.
   
7. Configure the roll-up calculation.
   

1. Summarized Object: Expense Items
   
2. Roll-Up Type: SUM
   
3. Field to Aggregate: Amount
   
4. Filter Criteria: All records should be included in the calculation
   
   

8. Click Next, Next, Save.
   

Nice job! You now have a new field on your Travel Approval object that automatically sums up your expenses. It has also been automatically added to your page layout. On to the next step, where you learn about formula fields.