Sum a group footer

[former_member736866]

I have a report that is has a a lot group footer. I need to sum up the data in Group Footer 5a and place the total in group footer 3. I need to sum up column:

Current Actual Cost (TOT_SALES_SCHED)

Estimate Cost (TOT_ACTUAL)

When I use running totals I get a large number that's the total for all rows in the report and not summing up this one section.

How do I GF5a total number and place the result in GF3?

[DellSC]

What are the formulas you're using for these columns in GF5?

[ido_millet]

Assuming the correct value of Current Actual Cost is repeated in each detail record, set the Running Total to evaluate once per Group Level 5 and Reset per each Group Level 3.

If the assumption above is wrong, please explain the actual detail-level data. A simplified example may be useful.

[former_member736866]

This worked for the field highlighted above. I tried to use this running total for the field Estimate Cost and it didn't work. Can you help calculate that total?