When using multiplication and division within Custom Summary Formulas, you can find that the results displayed within the Subtotal and/or Grand Total on your report may not be what you expect.
Typically, when working with the subtotal and Grand Total values within a report, the calculation returns the sum of the values for the prior groupings. With Custom Summary Formulas (CSFs) this behavior is handled differently. For Custom Summary Formulas, the evaluation is instead based on the sum of the contributing values. These summed values are then used by the formula.
For example:
Formula is Column A * Column B
| Record Name | Column A | Column B | Formula Result |
| Record 1 | 2 | 3 | 6 |
| Record 2 | 4 | 3 | 12 |
| Record 3 | 4 | 2 | 8 |
| SubTotal | 10 | 8 | ? |
The traditional expectation in this scenario would be that the Subtotal would result as a sum of the prior formula results. This would produce a calculation of (6 + 12 + 8=) 26. This is not the case when working with Custom Summary Formulas however.
The result is based on the sum of Column A multiplied by the sum of Column B. The calculation being performed as ((2+4+4)*(3+3+2)=) 80.
This is the current product's expected behavior. To vote and comment to have this behavior changed, please visit the Salesforce Idea Exchange, Fix Reports Grand Total Calculation Error.
Grand Total in Reports doesn't match Custom Summary Formula Totals
000387323

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.