You are here:
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
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
| Available for an additional cost in: Professional Edition with Web Services API Enabled |
| User Permissions Needed | |
|---|---|
| To create a tier payout rule for an accelerator: | A Spiff user role with these permissions turned on.
|
-
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.
- Create the range table according to your commission payout scenario.
- Create a data filter that determines which deals the calculation applies to, or use a prebuilt data filter, such as ClosedInPeriod.
- 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.
-
Create a worksheet.
-
Add a field that uses the
sum()function to sum calculations or synced fields. - Update the field name and the display name.
- Set the field format to Currency.
-
Add a field that uses the
-
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 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.lookup_value The total ARR calculated in the worksheet. table The range table you created. tiebreak_below Optional. See tier_payout. return_column Optional. See tier_payout. - In the datasheet, add a Commission column that multiplies the calculated rate by the ARR.
- Add a payout rule to a plan. Name the rule and select the field for the commission amount.
- Calculate the statement.
Did this article solve your issue?
Let us know so we can improve!

