You are here:
mamount
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.
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 |
Syntax
mamount(input_value, range_table, initial_value, return_column)Arguments
| Argument | Required? | Description |
|---|---|---|
| input_value | Required | The amount to check against a range table, such as the ARR from a closed deal. |
| range_table | Required | The range table to check. |
| initial_value | Optional | A starting value that affects which ranges the input_value applies to. Typically, this value is based on an accumulated variable, which tracks progress toward rate tiers. |
| return_column | Optional | The name of the range table's specific return column, enclosed in double quotes. This argument is required only if the range table includes multiple return columns, which is helpful when the same value ranges are used across multiple plans with different rates. |
Considerations
- This function calculates commission-specific amounts based on a rangle table and rate tiers.
- This function allocates input_value across tiers by calculating how much falls within each tier range, calculates the payout for each tier, and sums the results.
- You can use previously created summary calculations and mathematical operations in a range table. Reference these calculations with the syntax
WorksheetName!CalculationName.
Example
Consider these commission rate tiers in a range table, MarginalPayoutRangeTable.
- For the first tier of ARR closed, $0 to $150,000, a rep receives 4% commission.
- For the second tier of ARR closed, $150,000 to $250,000, a rep receives 8% commission, but that rate applies only to this tier. The first $150,000 is still commissioned at 4$.
If a rep closes $145,000 in ARR and then closes a new deal with $20,000 in ARR, only $5,000 of the new deal is allocated to the first tier at 4%. The remaining $15,000 is allocated to the second tier at 8%. The result is a blended rate, based on this calculation.
0.04 * 5,000 + 0.08 * 15,000)/20,000 = 7%To calculate this commission total, provide these values to the mamount() function.
=mamount(20000, MarginalPayoutRangeTable, 145000)This function returns the commission amount of $1,400, which is the 7% blended commission rate forthe $20,000 deal.
Did this article solve your issue?
Let us know so we can improve!
