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
MarkShnier__You
Qrew Legend
Qrew LegendAnthony, 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
------------------------------
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
------------------------------- 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
------------------------------- MarkShnier__YouIf the field called [Actual Commissions2] has the value 4200 in a record then the formula will calculate to 840.
But I think that you are confused as to what value is in that field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
