Formula fields are a great way to summarize your data in a clear and concise way. In this article, we will discuss how to create these formulas in both Lightning and Classic versions.
Add a Summary Formula Column in Lightning Experience
Edit or create the report you'd like to add the formula to.
If needed, group the report data.
From the Groups section, select a field from the Add group... lookup menu under GROUP ROWS.
From the Columns section, click
| Add Summary Formula Column OR from the Fields pane, under Summary Formulas, click + Create Formula.
Note: If a summary formula is available, but not yet added as a summary formula column, you can add it from the Fields pane. Under Summary Formulas, click | Add
Enter a name for the summary formula column.
Choose the Formula Output Type.
Enter a summary formula. For example:
IF(AMOUNT:SUM < 1000000, AMOUNT:SUM * (1 - 0.15), AMOUNT:SUM * (1 - 0.20))
Click Check Syntax. This will identify if there are any errors in your formula.
Optionally,
Enter a description for the formula
If applicable, choose the number of decimal points.
Click FORMAT to choose how to format results, how many decimal points to show, and to change where the formula gets applied.
Click Apply.
Click Save.
For Visual Learners: