---
schema_version: "1"
id: a7dfb583522e1a3e25d7d75c5305f47c1d16626f37d80ccc4806f04f6870787b
title: Create a Tier Payout Rule for an Accelerator
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_accelerator_tier_payout.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_tier_payout.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 73ac6bc92c5a7dbb35d2b3437f546bfb80977544f1b018ff78c7b1add90bbdec
description: Create a simple line-by-line tier payout rule based on a range table in Salesforce Spiff.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Create a Tier Payout Rule for an Accelerator

Create a simple line-by-line tier payout rule based on a range table in Salesforce Spiff.

### 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="d82009e77">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d82009e77 ">To create a tier payout rule for an accelerator:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d82009e77 ">
              <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 these permissions turned on.</p>
              <ul>
                <li>Designer Configuration: Manage</li>

                <li>Designer Range Tables: Manage</li>
              </ul>
            </td>

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

1. In Plans, create a folder for the tier payout rule.
    
    We recommend that you save all the items related to this rule in a convenient, shared location.
2. Create the range table according to your commission payout scenario.
3. Create a data filter that determines which deals the calculation applies to, or use a prebuilt data filter, such as ClosedInPeriod.
    
    See [Create a Data Filter in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_data_filter_create.htm&release=264.0.0&type=5 "Create data filters in Salesforce Spiff without writing any code.").
4. Create a datasheet in the same rule folder as the range table, specify an object and select the data filter you created, and add required fields.
    
    See [Create a Datasheet in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_datasheets_create.htm&release=264.0.0&type=5 "Analyze your data in new ways when you create and apply calculations to a specific set of filtered data.").
5. Create a worksheet.
    
    See [Create a Worksheet in Salesforce Spiff and Add a Calculation](https://help.salesforce.com/s/articleView?id=sales.spiff_worksheets_and_calculations_create_add.htm&release=264.0.0&type=5 "Define and manage sales compensation plans and determine the payouts based on those plans. Worksheets and calculations ensure that sales compensation is accurately and fairly distributed, aligning with the organization's goals and motivating the sales team.").
    
    1. Add a field that uses the `sum()` function to sum calculations or synced fields.
    2. Update the field name and the display name.
    3. Set the field format to Currency.
6. In the datasheet, add a calculated field that uses the `tier_payout()` function to look up the commission rate. Specify these values for the function's arguments.
    
    ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_tip.png)
    
    Tip If you don’t need a deal-by-deal calculation, create a worksheet calculation instead. You can then add a metric card to the rep statement and show the earned rate.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><th style="vertical-align:top;" headers="d82009e217-option" id="d82009e221"><samp class="parmname">lookup_value</samp></th><td style="vertical-align:top;" headers="d82009e217-desc d82009e221">The total ARR calculated in the worksheet.</td></tr><tr class=""><th style="vertical-align:top;" headers="d82009e217-option" id="d82009e231"><samp class="parmname">table</samp></th><td style="vertical-align:top;" headers="d82009e217-desc d82009e231">The range table you created.</td></tr><tr class=""><th style="vertical-align:top;" headers="d82009e217-option" id="d82009e241"><samp class="parmname">tiebreak_below</samp></th><td style="vertical-align:top;" headers="d82009e217-desc d82009e241">Optional. See <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_tier_payout.htm&amp;release=264.0.0&amp;type=5" title="Returns a payout amount from within an upper and lower range of values in Salesforce Spiff, based on a range table. This function returns the specified column expression for that value.">tier_payout</a>.</td></tr><tr class=""><th style="vertical-align:top;" headers="d82009e217-option" id="d82009e258"><samp class="parmname">return_column</samp></th><td style="vertical-align:top;" headers="d82009e217-desc d82009e258">Optional. See <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_tier_payout.htm&amp;release=264.0.0&amp;type=5" title="Returns a payout amount from within an upper and lower range of values in Salesforce Spiff, based on a range table. This function returns the specified column expression for that value.">tier_payout</a>.</td></tr></tbody></table>
7. In the datasheet, add a Commission column that multiplies the calculated rate by the ARR.
8. Add a payout rule to a plan. Name the rule and select the field for the commission amount.
9. Calculate the statement.

#### See Also

- [Line-By-Line Rule Examples](https://help.salesforce.com/s/articleView?id=sales.spiff_rules_line_by_line.htm&release=264.0.0&type=5 "Payout rules let you create calculations that determine how your reps earn a commission. Line-by-line rules calculate a commission amount by applying a calculation to each item in a data filter such as a deal or an opportunity. Calculation output from each item is summed to get the total for the rule.")
- [sum](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_sum.htm&release=264.0.0&type=5 "Calculates a total value from a list of numbers in Salesforce Spiff. This function works well with records in a data filter.")
- [tier\_payout](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_tier_payout.htm&release=264.0.0&type=5 "Returns a payout amount from within an upper and lower range of values in Salesforce Spiff, based on a range table. This function returns the specified column expression for that value.")