Running sum problem

[ascheper]

I have a formula field (@TotalFaxBack) in a report that calculates commission as:

if {@FaxBack} = &quot;Yes&quot; and {#OrderTotal} < 2000 then 25

else if {@FaxBack} = &quot;Yes&quot; and {#OrderTotal} > 2000 then 50

else 0


This is displayed for each order in the report. I need to create a sum of this for each salesman and the report will not let me create a running sum on the field. If anyone has any ideas, they would be greatly appreciated.

 

[IdoMillet]

Crystal can't aggreage aggregates (can't sum a sum)
and it seems like your {#OrderTotal} is indeed a sum...

Your best option may be to use a variable in a formula and increment it according to the condition above in each appropriate section.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com