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
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.
