--- schema_version: "1" id: a542080c8523f9065aa1242ab3d7dd87ea6fc3e1a171425d308cb50de8e75719 title: Considerations for Accelerator Functions in Salesforce Spiff collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_accelerator_functions.md canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_functions.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: c21fa442fafd8942657d0a03b18d8e8c323e2b21a794d4eaed512c4182f8286e description: Salesforce Spiff provides several functions that support accelerators, including mamount(), mpercent(), range_lookup(), and tier_payout. products: - Sales Cloud - Sales Enablement release: "264" --- # Considerations for Accelerator Functions in Salesforce Spiff Salesforce Spiff provides several functions that support accelerators, including `mamount()`, `mpercent()`, `range_lookup()`, and `tier_payout`. ### 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
## mamount() and mpercent() Some companies commission on a marginal or tax bracket basis and commission revenue amounts at different rates. Let’s say that income is taxed at these rates. - Income from $0 to $50,000 is taxed at a 5% rate - Income from $50,000 to $100,000 is taxed at a 6% rate - Income more than $100,000 is taxed at a 7% rate If someone earns $102,000 in a year, only the amount within each range is taxed at that corresponding rate. The first $50,000 is taxed at 5%, the next $50,000 is taxed at 6%, and the remaining $2,000 is taxed at the 7% rate. If you calculate commissions similarly, use the `mpercent()` and `mamount()` functions. These functions apply or return the right commission rate to the right amounts defined in a range table. Because of the accelerator functions' unique capabilities, create tables for the `mpercent()` and `mamount()` functions differently than tables used with the `range_lookup()` or `tier_payout()` functions. For example, a rep closed $220,000 in sales this month. The `mamount()` function returns the appropriate commission amount based on the closed amount. ``` =mamount(220000, ExampleAcceleratorTable) ``` The `mamount()` function performs this calculation, which results in $9,200 commission. ``` 4% × 200,000 + 6% × 20,000 + 8% × 0 + 10% × 0 ``` The function looks up the amount in the range table and allocates the appropriate amount of each deal into the appropriate tier. Only the amount that falls into each tier is multiplied by the corresponding rate. ![Accelerator table with three tiers](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_accelerator_create.png) Rather than returning the commission amount earned, managers and reps often want to know the rate that’s applied to the commissionable amount. You can use the `mpercent()` function. ``` =mpercent(220000, ExampleAcceleratorTable) ``` The `mpercent()` function performs this calculation, which results in 4.18% effective rate. ``` (4% × 200,000 + 6% × 20,000 + 8% × 0 + 10% × 0) ÷ 220,000 ``` ## tier\_payout() and range\_lookup() Some companies have plan components where a single commission rate applies to all of the deals the rep closes. Typically, companies track the highest tier or rate the rep achieves and then award the higher rate to all sales within the time period. Apply the `tier_payout()` function to the previous example where a rep closed $220,000 in sales this month. ``` =tier_payout(220000, ExampleAcceleratorTable) ``` The `tier_payout()` function looks up the amount in the range table to find the matching range and then returns the associated rate, which in this case is 6%. In another calculation, you can multiply the 6% against $220,000 to get the commission owed to the rep. The `range_lookup()` function is functionally equivalent. #### See Also - [mamount](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_mamount.htm&release=264.0.0&type=5 "Returns the commission total for a deal in Salesforce Spiff, based on a range table and the rep's current attainment. To return a commission rate instead, use the mpercent() function.") - [mpercent](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_mpercent.htm&release=264.0.0&type=5 "Returns the commission rate for a deal in Salesforce Spiff, based on a range table and the rep's current attainment. To return a commission total amount instead, use the mamount() function.") - [range\_lookup](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_range_lookup.htm&release=264.0.0&type=5 "Returns a value 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](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.")