I have a commissions calculation where I'm paying 20% of commissions owed for their first payment at a MAXIMUM of $1,000I 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?
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,000Example 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.