Loading

Spiff: Considerations for Accelerators

Julkaisupäivä: Aug 20, 2026
Kuvaus

Accelerators act as the high-performance engines of your payout rules in Spiff, amplifying earnings when your sales team achieves outstanding results. This article explains the role Spiff's Accelerators play in shaping commission structures, and how to configure and use them effectively in your commission plans.

Ratkaisu

This article explains how Spiff Accelerators work, how to build an Accelerator table, and what to consider when using accelerator functions in Spiff.

How to Create an Accelerator Table in Spiff

Accelerators can be created using a Range table and/or a Lookup table within your Spiff instance. When a rep surpasses their 100% sales goal, the Accelerator table automatically calculates their multiplier based on set conditions and timelines.

An Admin can create an Accelerator table by doing the following:

  1. In Spiff, click on the Designer button.
  2. Click on the Plan tab.
  3. Click the three dots next to the search bar and select New Range Table.
  4. Fill in the corresponding values in the Name, Lower Bound, Upper Bound, and Return Value columns. The Name column is the name of the tier. The Lower Bound and Upper Bound columns refer to the limits of each tier and are used to place the input value into a tier. Return values are the accelerators returned in the calculation.
  5. In the calculated field where the accelerator table needs to be used, use one of Spiff's Lookup or Commission functions with the newly created range table as the second argument. For example: `range_lookup(InputValue, "New Range Table Name", "Return Value Column")`.

Spiff Accelerator Functions

Spiff supports the following accelerator functions:

mpercent

  • This is a commission-specific function in Spiff that calculates tiered commission rates in a marginal fashion, similar to how income tax works.
  • Using an mpercent function requires a range table, and returns a rate from the specified return column rather than a number or dollar amount.

mamount

  • This is a commission-specific function in Spiff that is an updated version of the Marginal_payout function.
  • It calculates tiered commission amounts in a manner similar to how income tax works.
  • Using an mamount function requires a Range Table, and returns a commission total calculated using a range table's return column, rather than a commission rate.

tier_payout

  • This function works similarly to a vlookup function, but for a range of values.
  • It uses a Range Table, identifying which range a numerical value or variable falls into, and returns the specified column expression for that row.
  • Using the tier_payout function requires a Range Table.

Considerations for Accelerator Tables

  • Spiff does not support mixing decimal points and percent symbols in the same column in a range table.
  • A range table starts with 4 columns automatically: Name, Lower Bound, Upper Bound, and Return Value. We do not recommend renaming these columns, but you can add an additional column to your range table.
  • We recommend leaving the Lower Bound empty in the first row to cover any values up to the percentage set in the Upper Bound, and leaving the Upper Bound empty in the last row to cover all remaining values.
Knowledge-artikkelin numero

005239181

 
Ladataan
Salesforce Help | Article