Capped Commission Calculation
Hello!
I have a commissions calculation where I'm paying 20% of commissions owed for their first payment at a MAXIMUM of $1,000 I placed this formula in a formula - numeric field and it isn't ...
Forum Discussion
Hello everyone,
I used the MIN system however it still isn't calculating the amounts that I'm looking for.
The general idea is I want to pay 20% of the total amount of monies owed at a maximum of $1,000
Example 1: Commissions owed : $4,000 , 1st Payment (formula = $800)
Example 2: Commissions Owed: $10,000, 1st Payment (formula = $1,000)
I used the Min formula as described by Mark and in the same way it's been written it is giving me $1,000 as payment in Example 1 rather than $800.
Thank you so much again for your help.
------------------------------
Anthony Wong
------------------------------
Anthony, please post your current formula.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Here's my formula:
Min(1000,[Actual Commissions2]*0.2)
------------------------------
Anthony Wong
------------------------------- For the record which calculates incorrectly, what is the value of Actual Commissions2. ?
and why is it named with 2?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- The total amount is $4200
It's labeled with the 2 that way because it's a viewable commission that won't be shown as a negative number. It will maintain absolute value. We want to identify the negative commissions though compared to what's supposed to be paid out in the event that our costs exceed what's expected to be paid.
------------------------------
Anthony Wong
------------------------------
