---
schema_version: "1"
id: fe6b0fc0f142351458d02a4ae7b9293ff3bac66d2d9505d3f1712d6e19981c7c
title: Edit a Summary Formula Column
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/building_custom_summary_formulas_edit.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.building_custom_summary_formulas_edit.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 685adcc364965ca6ef44fdc667f236f11b7f25592c483b8654788d594a05355c
description: To update a summary formula after adding it to a report, edit it.
products:
  - Cross Cloud
release: "264"
---
# Edit a Summary Formula Column

To update a summary formula after adding it to a report, edit it.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enhanced Folder Sharing</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d56847e88">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d56847e88 ">To create, edit, and delete summary formula columns in private reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d56847e88 ">Enhanced Folder Sharing: Create and Customize Reports</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d56847e88 ">To create, edit, and delete summary formula columns in public and private
              reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d56847e88 ">Enhanced Folder Sharing: Report Builder OR Report Builder (Lightning
              Experience)</td>

          </tr>
        </tbody>
      </table>

The steps for editing 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png)

Note Summary formulas are powerful and complex. For help with building your formula, refer to [https://help.salesforce.com/articleView?id=customize\_functions.htm&language=en\_US](https://help.salesforce.com/articleView?id=customize_functions.htm&language=en_US) in Salesforce Help.

1. Edit a report.
2. From the Formula Columns section, click the formula column you want to edit. (Don't click **X**. It deletes the formula column. If you accidentally delete the formula column, undo the deletion by clicking **![the undo icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_button_undo.png)**.)
    
    Alternatively, from the Fields pane, under Summary Formulas, find the formula column you want to edit and click **![the more actions icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/resources-global/_corporate/images/dropdown.png)** | **Edit**.
3. Edit the summary formula.
4. To see if your formula contains errors, click **Check Syntax**. Resolve any errors.
5. Optionally, click **FORMAT** to choose how to format results, how many decimal points to show, and to change where the formula gets applied.
6. Click **Apply**.
7. Click **Save**.

The summary formula column updates to reflect your edits.

## Edit a Summary Formula Column in Salesforce Classic

1. Edit a report.
2. From the Fields pane, find the summary formula you want to edit and click **![the pencil icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/pencil.png)**.
    
    The Custom Summary Formula menu opens.
3. Enter a name for your formula column. The label must be unique. Optionally, enter a description.
4. From the Format dropdown list, select the appropriate data type for your formula based on the output of your calculation.
5. 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.
6. 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.
7. 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.
8. To see if your formula contains errors, click **Check Syntax**.
    
    If there are errors, the cursor highlights them.
9. Click **OK**.
10. Click **Save**.