---
schema_version: "1"
id: 217c7c939d7a029a1cc79654013448979e613f65de0f3cd3a583e0eec59c69db
title: "Get the Most Out of Row-Level Formulas: Tips, Limits, and Limitations"
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_limits.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_formulas_row_level_limits.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: cbd63cf73e52e52ec85d5fbb97c1abab7f47b92ce442935a031a82cd59e25a35
description: As you get ready to write row-level formulas, review these tips, limits, and limitations.
products:
  - Cross Cloud
release: "264"
---
# Get the Most Out of Row-Level Formulas: Tips, Limits, and Limitations

As you get ready to write row-level formulas, review these tips, limits, and limitations.

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

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

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

- Each report supports 2 row-level formulas.
- Each row-level formula can reference up to 5 unique fields. If the formula references the same field 5 times, that counts as referencing 1 unique field.
- You can't use row-level formulas for:
    - Cross filters
    - Buckets
- Row-level formulas can't reference:
    - Bucket fields
    - Summary formulas
    - Other row-level formulas
- Row-level formulas don't support these field types:
    - Boolean
    - Timeonly
    - Email
    - Phone
    - Multiselect picklist
- Some date fields aren't supported, including:
    - Due Date
    - Birthdate
- Some text fields aren't supported, including:
    - Billing Address
- Row-level formulas always use an org's default currency. Row-level formulas don't respect multi-currency settings on reports.
    
    For example, if USD is your org's default currency and a report is set to show GBP, the row-level formula displays USD.
- "With or Without" custom report types (like Accounts with or without Contacts) don't support row-level formulas. The **Add Row-Level Formula** button doesn't appear.
- You can create row-level formulas on historical trend reports, but you can't reference historical fields in row-level formulas.
- Reporting snapshots don't support row-level formula fields.
- Row-level formulas aren't available on joined reports. To convert a report with row-level formulas into a joined report, first remove the row-level formulas.
- The embedded Salesforce Classic report builder in Lightning Experience doesn't support row-level formulas. If a report has a row-level formula, then the **Edit (Salesforce Classic)** button doesn't appear.
- You can't create, edit, or delete row-level formulas from the Fields panel. Create, edit, or delete them from the OUTLINE panel.
- Row-level formulas aren't available in Salesforce Classic. You can't run or edit reports with row-level formulas in Salesforce Classic.
- Row-level formulas aren't available in the Apex API.