I have a report that is summarizing two amounts based on group #1, account number. Previous Total and Existing Total.
I then have a formula, @Difference that calculates the difference, Existing - Previous
I then have a third formula, Net Amount, that says if @Difference > 0 then @Difference else 0.
All of these formulas are working just fine. However, I now want to Sum the third formula Net Amount in the Report Footer. However, I am getting error messages saying that the Net Amount cannot be summarized. I've tried using ToNumber, I've tried making it a Local Numbervar, and I'm out of ideas.
Any help in getting Crystal to summarize this field would be greatly appreciated.
i already got the sum of all the subtotals using the techniques you posted. but there's one thing more i'd like to do. i'd like to get the average of all the subtotals i've just summed up. or just divide the sum to the no. of group. how will i do this?