Salesforce Reports support a maximum of 5 Custom Summary Formula fields per report. A Custom Summary Formula is a report feature that allows users to create calculated fields based on summary (aggregate) data in summary, matrix, or joined reports. This limit is hard-coded and cannot be changed by configuration or by Salesforce Support.
To request that this limit be increased in a future Salesforce release, submit or vote on Increase Limits for Summary Formula Fields in Reports on the IdeaExchange.
If your Salesforce report requires more than 5 calculated summary fields, consider the following workarounds:
Option 1: Create Formula Fields on the Object
Create the formula as a custom formula field directly on the target Salesforce object (for example, Opportunity or Account). These object-level formula fields can then be included as standard columns in your report without consuming a Custom Summary Formula slot. This approach is best suited for calculations that are always needed at the record level.
Option 2: Split Into Multiple Reports
Split the reporting requirement into multiple reports, each using up to 5 Custom Summary Formulas. Consolidate the results using a joined report or a dashboard with multiple components.
For more on summary formulas, see Get the Most Out of Summary Formulas: Tips, Limits, and Limitations.
000384800

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.