I created a commission report telli

[alfred723]

I created a commission report telling me how much commission a salesman gets for total sale. there are different commission rates for different items. I'm having trouble creating a formula telling Crystal reports to sum the commission totals by commission rates. Can someone please help??

 

[MJRBIM]

Could you provide more info? Version of CR, database, etc...

Please post a sample of your data with headers and a sample of what you need to see as results.

 

[dgillz]

Please post your formula for commission calculations.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Madawc]

In Crystal 8.5, you'd need a formula to multiply commission totals by commission rates. And then a running total to sum the formula.

Madawc Williams
East Anglia, Great Britain

 

[alfred723]

I created a commission report telling me how much commission a salesman gets for total sale. there are different commission rates for different items. I'm having trouble creating a formula telling Crystal reports to sum the commission totals by commission rates. Can someone please help??


DATE SALESMAN# PRODUCT WEIGHT AVG. EXTENSION
CODE PRICE


8/15/03 10 002 10 3.99 39.90
8/17/03 10 007 3 3.19 9.57
8/20/03 12 012 240 1.90 456.60
8/15/03 17 178 5 2.17 10.85
COMMISSION PRODUCT TOTAL PRODUCT
RATE COMMISSION COMMISSION NAME

.0340 .34 .34 TBONE
.0340 .10 .10 CHUCK STEAK
.0240 5.76 5.76 BONLESS STEW
.0165 .08 .08 CHEESE


(COMMISSION TOTALS ARE SEPERATED BY SALESMAN AND COMMISSION RATE)

TOTALS FOR SALEMAN # (SALESMAN # WOULD GO HERE)

.0340 .0240 .0165
(COMMISSION TOTALS WOULD GO HERE BY COMMISSION RATES )

NEXT PAGES WOULD HAVE OTHER SALESMAN TOTALS BY COMMISSION RATES. PLEASE HELP