---
schema_version: "1"
id: 459667ae381cb840ff406a1c6cd235e315a25130274f8d2ba465f0d91b62d3af
title: Edit a Row-Level Formula
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_formulas_row_level_edit.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level_edit.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 39bbbb088b61aada8f4f565eba7ff4bb8a0db8518949f50ad93eee47430a1d0f
description: Edit a row-level formula to expand, refine, or change how it evaluates report data.
products:
  - Cross Cloud
release: "264"
---
# Edit a Row-Level Formula

Edit a row-level formula to expand, refine, or change how it evaluates report data.

### 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: 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="d50836e88">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d50836e88 ">To create, edit, and delete formulas in private reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d50836e88 ">
              <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="d50836e88 ">To create, edit, and delete formulas in public and private reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d50836e88 ">
              <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>

Edit row-level formulas directly in the Lightning report builder. Here's how.

1. Edit a report.
2. From the Columns section of the OUTLINE pane, click the row-level formula column's name. For example, if the row-level formula you want to edit is named Time to Close, then click **Time to Close** (1).
    
    ![Adding a row-level formula](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_reports_formulas_row_level_edit_1.png)
3. From the Edit Row-Level Formula Column window, edit the **Column Name** (2), choose a **Formula Output Type** (3), and edit the **Formula** (4). If applicable, edit the **Description** and change the number of **Decimal Points**.
    
    To test your formula for errors, click **Validate**. If necessary, resolve any errors. Then, click **Apply** (5).
    
    ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_tip.png)
    
    Tip For a little row-level formula inspiration, see [Examples: Evaluate Each Record in Reports with Row-Level Formulas](https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level_examples.htm&release=264.0.0&type=5 "\"How many days did it take each opportunity to close? Which case subjects mention the word widget?\" Here's how to write row-level formulas that answer these business questions, and others.") in Salesforce Help.
    
    To learn more about writing formulas, see [Formula Operators and Functions by Context](https://help.salesforce.com/s/articleView?id=platform.customize_functions.htm&type=5&language=en_US) in Salesforce Help.
    
    ![Writing a row-level formula](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_formulas_row_level_2.png)
4. The edited row-level formula appears as a column on the report (6).
    
    ![A row-level formula in a report](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_formulas_row_level_3.png)
5. To save and run the report, click **Save & Run**.

The row-level formula column on the report is updated to reflect your edits.