My initial problem was that when I summed detail lines in the report footer it was also summing lines that I was suppressing.  I added a formula that used the same logic as the suppression so that if the detail was suppressed then the formula would = zero.  If not it would equal the line total.  This works.  The problem is that I it will not allow me to summarize that formula.

Here is the formula:

IF {QuoteDtl.DisplaySeq} = 1.000 THEN
    {QuoteDtl.SellingExpectedQty} * {@LinePriceWithDiscount}
ELSE
    IF (ToText((Previous({QuoteDtl.DisplaySeq})),0) = {@SalesKitLine}) THEN 0 ELSE {QuoteDtl.SellingExpectedQty} * {@LinePriceWithDiscount};

If I remove the "ToText" portion of the formula then it does allow me to summarize it.

Any thoughts?

I second DBlank's answer. I like shared variables myself...for no good reason running totals confuse me...but they both do about the same thing.

the reason that CR can't summarize, is that when it is reading the data for the aggregate phase (avg, sum, count) it doesn't know which record is going to previous or next, and so it can't summarize a formula like this.

If all the data the you wanted to summarize or use in the logic was on 1 line, and then CR can do it. Add in logic when you want to pick and choose which values to include and CR can no longer summarize and you need to use of the 2 methods mentioned by DBlank.

HTH