Have a group footer where the client wants (that is always my disclaimer) a field that is field1 - sum(field2). field1 is not a sum, just the last field value. But field2 needs to be the sum of all the field2 within the Data Grouping. if I click the Sum radio button within Calculate Field, it becomes sum(field1) - sum(field2). without the Sum radio button it is field1 - field2.

Any ideas?

Brenda