Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How do you know which commission rate to use?
Hi Jason:
It is by the option whether it is option 1 or option2 to determine the commission rate.
Thanks
Any suggestion guys?
Please give some suggestion thanks alot...
Any suggestion guys?
Please give some suggestion thanks alot...
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