I have 3 different types of columns in my group footer

a. A standard summary based on standard DB fields
b. A formula which calculated & compiled results from a sub report
c. A totals field which needs to be (a-b)

I don't know if it's necessary to get into further details, but when I first built this report the key results were in the Details field and it worked just fine, but the data has expanded causing duplicate detail results of the grouped item so I had to suppress the details and move the fields into the group footer.  I have a and b displaying the correct results, but is there a quick and easy way to do c?

I suppose I could rework all the 'a' columns (there's more than one) with shared variables and manual sum formula's, but I'm thinking there's gotta be a much easier way of doing that.

Yes that's exactly what I needed, I knew I was overlooking something.  Thanks.  

Edited by Rand - 27 Oct 2011 at 9:40am