Tried to find the answer.... taking so much time. and not getting anything..
I'm working on report which calculates commission based on some rules.
RepName OrderNo TotalAmount GrossMargin Date
AAA 122 234.22 25
AAA 123 600.32 34.53 2010-04-06
BBB 124 1211.21 219.99 2010-05-04
and so on...
There are some rules. and thats where I'm kind of stuck....
We count commission on grossmargin. and for individual sales rep, for every quarter, if total of their grossmargin goes to 10000.00$, then commission percentage is 5%.
if its 10001.00 to 20000.00
View Complete Post