How to combined the old Expression into new commission rate?

[#1]

Hi Guys:

I need some kind help here.

I have an old Expression as follow:-

UHT 1L

(sum(if(DeliveryYearMonth<=CurrentYearMonth and ((trim([Item Code]) ='011500' or trim([Item Code]) ='011505'

or trim([Item Code]) ='011510' or trim([Item Code]) ='011511'

or trim([Item Code]) ='011515' or trim([Item Code]) ='012500'

or trim([Item Code]) ='012501' or trim([Item Code]) ='012502'

or trim([Item Code]) ='012505' or trim([Item Code]) ='012510'

or trim([Item Code]) ='012511')),DeliveryQuantity/[INCENTIVE RATE]))) * 0.06

The old commission is $0.06 but now we are having new commission rate as follows:-

Option 1:-

1 pax team 50% and 50%( eg. $0.15 and $0.15)

2 pax teams 60% and 40% (e.g. $0.18 and $0.12)

3 pax team 40%, 30% and 30% (e.g. $0.20, $0.15 and $0.15)

Option 2:-

3 pax team 40%,30% and 30% ($0.2089, $0.1567 and $0.1567)

I am trying to include these new commission into the old expression.

Can anyone please show some light?

Thanks

[Jason_Michaelides]

How do you know which commission rate to use?

[#3]

Hi Jason:

It is by the option whether it is option 1 or option2 to determine the commission rate.

Thanks

[#4]

Any suggestion guys?

Please give some suggestion thanks alot...

[#5]

Any suggestion guys?

Please give some suggestion thanks alot...

[jonathandienst]

Hi

I suspect that no-one really understands your requirements (I certainly don't). Please clarify what you mean by the new commission structure (without using abbreviations) and if possible, post a sample of your application.

Regards

Jonathan