---
schema_version: "1"
id: 7b97f105b59941a4648321fa38a1963b67093bd030ee2a46be80af9083905f22
title: Hide a Zero Payout Lump-Sum Rule
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_rules_zero.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_rules_zero.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c52eecec64a086bf5a2f72902834c0a1c4a157cb3df16198a65309da4f2c40bc
description: When a lump-sum rule has zero payout, you can hide the rule.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Hide a Zero Payout Lump-Sum Rule

When a lump-sum rule has zero payout, you can hide the rule.

### 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: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</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="text-align:center;vertical-align:top;" id="d72441e77">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d72441e77 ">To change a lump-sum rule to a line-by-line rule:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d72441e77 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with this permission turned on.</p>
              <p style="margin-bottom:0;">Designer Configuration: Manage</p>
            </td>

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

Maybe you want to hide zero payout lump-sum rules in these scenarios.

- A rep is fully ramped.
- Specific reps on a plan aren't receiving certain commission payouts.
- A statement is cluttered and you want to simplify the information that's shown.

For example, maybe you have a lump-sum rule that gives all reps a $50.00 payout in February, but the current statement period is January, so you don't want to show a line of $0.00 in the January statement.

![Statement showing zero bonus amount](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_rules_zero_hide_statement.png)

To avoid this scenario, convert the lump sum rule to a line-by-line rule. A line-by-line rule doesn't appear on statements when the rule's filter doesn't return any records for the statement period.

1. Find the lump-sum rule you want to change, and find its corresponding worksheet calculation.
    
    For example, find the FebruaryBonus calculation.
    
    ```
    =if(isFebruary, 50, 0)
    ```
    
    ![Lump-sum payout calculation on worksheet](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_rules_zero_hide_current.png)
2. Create a worksheet calculation, FebBonusRep, that returns the rep's ID dynamically.
    
    The worksheet field returns the current RepId or a blank string, depending on whether the payout is greater than 0. This example uses the `ZeroInCompanyCurrency` and `RepId` helper functions.
    
    ```
    =if(FebruaryBonus > ZeroInCompanyCurrency, RepId, "")
    ```
    
    ![Worksheet calculation for returning RepId](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_rules_zero_hide_repid.png)
3. Create a data filter on the User object that returns the current rep’s row.
    
    This data filter returns a maximum of one row, or returns no rows if the payment is zero.
4. Create a datasheet, select the User object, and apply the new filter.
5. Create a calculated field that references the original worksheet calculation that calculates the lump-sum amount for the original rule.
6. Change the lump-sum rule to a line-by-line rule by referencing the new field.
    
    ![Changing a lump-sum rule into a line-by-line rule](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_rules_zero_hide_change.png)