>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

Try creating a report variable that sums field2 (call it sumfield2). Your group footer would then contain field1 - sumfield2. You would not have to have the footer field do any other calculating or summing.