If you use the min formula in the way you are describing then it will work fine. Are you 100% positive you know what number is coming through and being used for the calculation?

The way Min works is you feed it a bunch of numbers and it spits out the smallest one.

Min(1000, 4000 * 0.2) would calculate to 800. That's why Mark is suggesting you may not be dealing with the numbers you think you are if you are not seeing the same calculation. Math only tells the truth here, use it to find what is happening with the data.

What I usually do is show all fields used in the calculation on the form when building it out if I am having an issue. That way you can follow the calculation and see where it is having an issue.

Original Message:

Sent: 06-28-2022 17:39

From: Anthony Wong

Subject: Capped Commission Calculation

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

Original Message:

Sent: 06-28-2022 11:18

From: Karen Smith

Subject: Capped Commission Calculation

You might already have an answer, but I think you want to use MIN not Max.

Original Message:

Sent: 6/27/2022 8:49:00 PM

From: Anthony Wong

Subject: 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

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