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.

[former_member736866]

I see the problem with the calculations, the GF5a section has suppress logic and the total is for all the records. Is there a way to calculate only the data visible and not the suppress records?

Here is the suppress logic:

if {?Summary Only} = 'Yes' then yes else

if {@Line Cost} > .01 then no else

if Mid(trim({PPJOBD.COMPONENT_CAT_NO}),1,3) = "INV" then no else

if {#Sum Job Line Price x Qty} + {#Sum Job Line Weight} + {#Sum Hours x Job Line Qty} = 0 then yes else no

[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?