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

------------------------------