Add a Summary Formula to a Joined Report

Add a summary formula to a joined report in Lightning Experience

1. Create or edit a joined report.
2. Ensure that there is at least one grouping on the joined report. If necessary, group data by clicking Add group... and selecting a field to group by.
3. From the Columns section of the Outline panel, click adjacent to a block name.
4. To add a summary formula that only evaluates data in one block, click Add Summary Formula. To add a cross-block summary formula that evaluates all the data in the joined report, click Add Cross-Block Summary Formula.
5. Write the formula. For help with writing the formula, see Evaluate Groups and Totals with Summary Formulas.
6. Click Apply.

Add a custom summary formula to a joined report in Salesforce Classic

1. Create or edit a joined report.
2. Ensure that there is at least one grouping on the joined report. If necessary, group data by dragging and dropping a field onto the area that reads Drop a field here to group across report blocks.
3. To add a standard custom summary formula, from the Fields pane, go to the report type category and double-click Add Formula. To add a cross-block custom summary formula, from the Fields pane, go to the Common category and double-click Add Cross Block Formula.
4. Write the formula. For help with writing the formula, see Evaluate Groups and Totals with Summary Formulas.
5. Click OK.

The summary formula column appears in your report.