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
You might already have an answer, but I think you want to use MIN not Max.
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
------------------------------
- MarkShnier__You
Qrew Legend
Anthony, please post your current formula.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Here's my formula:
Min(1000,[Actual Commissions2]*0.2)
------------------------------
Anthony Wong
------------------------------- MarkShnier__YouFor 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
------------------------------
- If you use the min formula in the way you are describing then it will work fine. Are you 100% positive you know what number is coming through and being used for the calculation?
The way Min works is you feed it a bunch of numbers and it spits out the smallest one.
Min(1000, 4000 * 0.2) would calculate to 800. That's why Mark is suggesting you may not be dealing with the numbers you think you are if you are not seeing the same calculation. Math only tells the truth here, use it to find what is happening with the data.
What I usually do is show all fields used in the calculation on the form when building it out if I am having an issue. That way you can follow the calculation and see where it is having an issue.
