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]

Use the suppress logic in reverse to create a formula such as:

IF NOT <your Suppress Condition> 
THEN <your field value> 
ELSE 0

Then, SUM that formula.