Loading
Analyze Your Data
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Add a Summary Formula Column to a Report

            You are here:

            1. Salesforce Help
            2. Docs
            3. Reports and Dashboards

            Add a Summary Formula Column to a Report

            Before adding a summary formula to your report, be sure to group report data. Summary formula columns require at least 1 group.

            Required Editions

            Available in: Salesforce Classic and Lightning Experience
            Available in: Essentials, Group, Professional, Enterprise, Performance, Unlimited, and Developer Editions
            Available in: Enhanced Folder Sharing
            User Permissions Needed
            To create, edit, and delete summary formula columns in private reports:
            Enhanced Folder Sharing
            Create and Customize Reports
            To create, edit, and delete summary formula columns in public and private reports:
            Enhanced Folder Sharing

            Report Builder OR Report Builder (Lightning Experience)

            Summary formula columns are available in both Lightning Experience and Salesforce Classic. They use the same formula language, so the summary formulas you add in Lightning Experience work in Salesforce Classic, and vice versa.

            The steps for adding a summary formula column are a little different depending on whether you’re using Lightning Experience or Salesforce Classic. Follow the instructions based on whether you’re using the Lightning Experience or the Salesforce Classic report builder.

            Note
            Note Summary formulas are powerful and complex. For help with building your formula, refer to Formula Operators and Functions by Context in Salesforce Help.

            If you apply a summary formula column to a second-level grouping and use it as a measure in a chart, the chart won't show results.

            The summary formula column appears in your report.

            See Also

            Add a Summary Formula Column in Lightning Experience

            1. Edit or create a report.
            2. If necessary, group report data. From the Groups section, select a field from the Add group... lookup menu under GROUP ROWS.
            3. From the Columns section, click the more actions icon | Add Summary Formula Column.

              Alternatively, from the Fields pane, under Summary Formulas, click + Create Formula.

              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 the more actions icon | Add

            4. Enter a name for the summary formula column.
            5. Choose the Formula Output Type.
            6. Enter a summary formula.
              For example:
              IF(AMOUNT:SUM < 1000000, AMOUNT:SUM * (1 - 0.15), AMOUNT:SUM * (1 - 0.20))
            7. To see if your formula contains errors, click Check Syntax. Resolve any errors.
            8. Optionally, enter a description for the formula.
            9. If applicable, choose the number of decimal points.
            10. Optionally, click FORMAT to choose how to format results, how many decimal points to show, and to change where the formula gets applied.
            11. Click Apply.
            12. Click Save.

            Add a Summary Formula Column in Salesforce Classic

            1. Edit or create a report.
            2. If necessary, group report data. Change the format to Summary, Matrix, or Joined, find the field you want to group by, and drop it into the grouping field.
            3. From the Fields pane, in the Formulas folder, click Add Formula.
            4. Enter a name for your formula column. The label must be unique. Optionally, enter a description.
            5. From the Format dropdown list, select the appropriate data type for your formula based on the output of your calculation.
            6. From the Decimal Places dropdown, select the number of decimal places to display for currency, number, or percent data types. This setting is ignored for currency fields in multicurrency organizations. Instead, the Decimal Places for your currency setting apply.
            7. Set the Where will this formula be displayed? option. The formula calculation displays in the report at the level you select. To display the formula calculation at every level, including the Grand Total, select All summary levels.
            8. Build your formula.
              1. Select one of the fields listed in the Summary Fields dropdown list. This field's value is used in your formula.
              2. Select a summary type for use in your formula. This option isn't available for Record Count.
                Summary Type Description
                Sum The summary value of data in a field or grouping of fields.
                Largest Value The largest value of data in a field or grouping of fields.
                Smallest Value The smallest value of data in a field or grouping of fields.
                Average The average of data in a field or grouping of fields.
              3. To add operators (like > or <) to your formula, click Operators.
              4. Select the function category (All, Logical, Math, or Summary), choose the function you want to use in your formula, and click Insert.
              5. Repeat these steps as necessary.
            9. To see if your formula contains errors, click Check Syntax. If there are errors, the cursor highlights them.
            10. Click OK.
            11. Click Save.
             
            Loading
            Salesforce Help | Article