# Getting Started

View Only

## Capped Commission Calculation

• #### 1.  Capped Commission Calculation

Posted 06-27-2022 20:49

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

• #### 2.  RE: Capped Commission Calculation

Posted 06-28-2022 11:18

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

• #### 3.  RE: Capped Commission Calculation

Posted 06-28-2022 17:39

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

• #### 4.  RE: Capped Commission Calculation

Posted 06-28-2022 18:40

------------------------------
mark.shnier@gmail.com
------------------------------

• #### 5.  RE: Capped Commission Calculation

Posted 06-28-2022 18:51
Here's my formula:

Min(1000,[Actual Commissions2]*0.2)

------------------------------
Anthony Wong
------------------------------

• #### 6.  RE: Capped Commission Calculation

Posted 06-28-2022 19:02
For the record which calculates incorrectly, what is the value of Actual Commissions2.   ?

and why is it named with 2?

------------------------------
mark.shnier@gmail.com
------------------------------

• #### 7.  RE: Capped Commission Calculation

Posted 06-28-2022 19:07
The total amount is \$4200

It's labeled with the 2 that way because it's a viewable commission that won't be shown as a negative number. It will maintain absolute value. We want to identify the negative commissions though compared to what's supposed to be paid out in the event that our costs exceed what's expected to be paid.

------------------------------
Anthony Wong
------------------------------

• #### 8.  RE: Capped Commission Calculation

Posted 06-28-2022 19:38
If the field called [Actual Commissions2] has the value 4200 in a record then the formula will calculate to 840.

But I think that you are confused as to what value is in that field.

------------------------------
mark.shnier@gmail.com
------------------------------

• #### 9.  RE: Capped Commission Calculation

Posted 06-29-2022 12:27
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.