I have to determine a commission percentage based on the total grossprofit. We have three different levels and I want to have the query pick the rate. >300000 is 12% >600000 is 15% and over 600000 is 18%.?
I would like to create a running total of all the grossprofits plus the grossprofit by salemen....this is what my report displays.