---
schema_version: "1"
id: 1766efbe61ad08dabd199449d8e1c1d62b8060594bba8474ca9ac0fe41635200
title: Delete 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_delete.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.building_custom_summary_formulas_delete.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a8e41be74bcb91e10e0714c4bcc5dd56764696bba5a36a9e13a87a9e08b151e7
description: If you no longer need a summary formula column, delete it.
products:
  - Cross Cloud
release: "264"
---
# Delete a Summary Formula Column

If you no longer need a summary formula column, delete 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="d64545e88">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d64545e88 ">To create, edit, and delete summary formula columns in private reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d64545e88 ">
              <dl>

                <dt style="font-weight:bold;padding-top:.25rem;">Enhanced Folder Sharing</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">Create and Customize Reports </dd>

              </dl>
            </td>

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

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d64545e88 ">
              <dl>

                <dt style="font-weight:bold;padding-top:.25rem;">Enhanced Folder Sharing</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">
                  <p style="margin-bottom:0;">Report Builder OR Report Builder (Lightning Experience)</p>
                </dd>

              </dl>
            </td>

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

The steps for deleting 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.

Delete a Summary Formula Column in Lightning Experience

1. Edit or create a report.
2. From the Formula Columns section, find the summary formula column you want to remove and click **X**. When you remove a summary formula this way, it's still available in the Fields pane under Summary Formulas. You can add it back to the report as a summary formula column from the Fields pane later.
    
    Alternatively, from the Fields pane, under Summary Formulas, find the formula column you want to edit and click **![the show more 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)** | **Delete**. When you delete a summary formula this way, it is removed for good. If you want to add it back later, you'll have to rewrite it.
3. Click **Save**.

Delete a Summary Formula Column in Salesforce Classic

1. Edit or create a report.
2. From the Fields pane, in the Formulas folder, find the summary formula column you want to delete and click **![the delete icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/reportbuilder_trashcan.png)**
3. Click **Save**.

The summary formula column is removed from your report.

In Lightning Experience, If you accidentally delete a formula column in Lightning Experience, 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)**.

In Salesforce Classic, you can’t undo a deletion. If you can’t undo the deletion, deleting a summary formula column is permanent. To get it back, you’ll have to recreate it from scratch.