AnthonyWong1
3 years agoQrew Member
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 keeping the maximum number capped at $1,000.
Max(1000, [Actual Commissions]*0.2)
I tried switching the the items between the comma and it still didn't work. Can someone please help?
Thank You
------------------------------
Anthony Wong
------------------------------