I am using Crystal Reports 2011.

I have a report with a subreport.  I have a shared variable that passes last year's item price from the subreport to the main report.  I then have a formula that subtracts that shared variable from this year's price to give me the difference between the two.

I have another formula that then takes that difference and multiplies it by the quantity ordered this year to give me a gross revenue increase.

I am running into a problem trying to summarize the gross revenue increases; the formula that calculates the increase is not available in the dropdown list when I try to create a summary.

Here are the formulas and their locations:

@Difference (not on the report canvas)-

{Invoice.PRICE} - {@Prior Year Price Shared}

Main Report:

Group Footer 3a:

@PriorYearPrice Shared-

WhilePrintingRecords;
Shared NumberVar PriorYearPrice;
PriorYearPrice

Group Footer 3b:

@Revenue Increase-

If {@Difference} = 0
then
0
else
Sum ({Invoice.SHIPQTY}, {Invoice.PRTNUM}) * {@Difference}

Subreport:

Group Footer 2

PriorYearPrice Shared-

WhilePrintingRecords;
Shared NumberVar PriorYearPrice:= {Invoice.PRICE}

How can I summarize the individual Revenue Increases as a Grand Total in the Report Footer?

Sastry,

That did the trick!  Thank you ever so much!  You've made my CEO a happy man.