Getting Started

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

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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