---
schema_version: "1"
id: 60d25e0340cffa8a8784acd8416b1efae98b2a9ac929f682c89f0a61c3363ca6
title: Evaluate Each Record in Reports with Row-Level Formulas
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.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5a5c3669e83607bf8bf7d6f9e28568668dacffc3bf7509eec85c0b5c2b379379
description: Answer business questions like "how many days did it take each opportunity to close?" by using row-level formulas that evaluate each record in a report.
products:
  - Cross Cloud
release: "264"
---
# Evaluate Each Record in Reports with Row-Level Formulas

Answer business questions like "how many days did it take each opportunity to close?" by using row-level formulas that evaluate each record in a report.

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

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

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

To answer common questions like these, you need to assess each record in a report:

- How many days did it take each opportunity to close?
- Which cases mention the word "widget"?
- As defined by a customer satisfaction (CSAT) score, which customers are satisfied or upset?

The answer to these questions, and many more, are a row-level formula away.

- **[Write a Row-Level Formula](https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level_add.htm&release=264.0.0&type=5)**  
    Writing a row-level formula adds a row-level formula column to your report that makes calculations on every report row. Write row-level formulas directly in the Lightning report builder.
- **[Edit a Row-Level Formula](https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level_edit.htm&release=264.0.0&type=5)**  
    Edit a row-level formula to expand, refine, or change how it evaluates report data.
- **[Delete a Row-Level Formula](https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level_delete.htm&release=264.0.0&type=5)**  
    When you no longer need a row-level formula in your report, delete it.
- **[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.
- **[Get the Most Out of Row-Level Formulas: Tips, Limits, and Limitations](https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level_limits.htm&release=264.0.0&type=5)**  
    As you get ready to write row-level formulas, review these tips, limits, and limitations.