How to add to a group amount? Crystal 10

[travelerII]

I have sales $ information that is grouped by dimension, in this case, manufactured, stock, other, freight, etc. We calculate freight and other in two different ways on sales invoices. So I had to write a formula to capture the second amount from the invoice elements. I placed the sum of this formula in the footer below my groups. Now I need to add the two freight together and the two others together for a total. I was able to write a formula that did the trick but only for which ever group was on the last line of the group sort. Since I can't have both freight and other on the bottom line of the groups how do I solve this problem.
Here is the formula I wrote to add the two freights together.
if {@Dimensions} = "Freight and Handling" then
Sum ({@Current YTD Freight})+ Sum ({@Current YTD Amount}, {@Dimensions})
else
0

Any help is appreciated.

 

[Madawc]

You don't need to put 'Sum' in a formula. You can have a formula that includes or excludes a value at detail-line level. You can then sum such values.

Alternatively, you can have a running total based on a rule.

The use of Crystal's automated totals is outlined at FAQ767-6524. Worth writing a few test reports to get familiar with what these totals do.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP