AnthonyWong1
Qrew Member
3 years ago

# 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
------------------------------
• 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
------------------------------