Running Totals and Suppressed records

[kbrown73]

I am suppressing records that have a particular field that is equal to 0. (I can't use select expert to omit the record because I need another field value from the record for the following record.) I do not want the running totals calculated for other fields in the suppressed record. How can this be accomplished using the running totals?

 

[kbrown73]

Here is sample data:

NAME PCS DOWNREASON DOWNTIME
Job1 100 Machine 1200
Job1 100 Break 15
Job1 100 Startup 25
Job2 532 Break 15
Job2 532 Startup 32
Job2 532 Meeting 10
Job2 532 MoldChange 35
Job3 0 NotSched 265 (This record would be supp.)
Job3 0 Machine 45 (SAME)
Job3 0 MoldChange 35 (SAME)

TOTALS: 1332 (should be the total)

 

[lbass]

When you create the running total, choose evaluate based on a formula and enter:

{table.pcs} <> 0

-LB

 

[kbrown73]

That works for one of the field running totals, thanks. But I have another field that is calculating a running total on the change of a field (the job field). Here is sample data:

NAME PCS DOWNREASON DOWNTIME TOTALMACHINEDT
Job1 100 Machine 1200 1240
Job1 100 Break 15 1240
Job1 100 Startup 25 1240
Job2 532 Break 15 92
Job2 532 Startup 32 92
Job2 532 Meeting 10 92
Job2 532 MoldChange 35 92
Job3 0 NotSched 265 345
Job3 0 Machine 45 345
Job3 0 MoldChange 35 345

TOTALS: 1332 1677

Is there a way in the formula to evaluate on the change of field.

Thanks again

 

[lbass]

Change the evaluation formula to:

(onfirstrecord or
{table.jobfield} <> previous({table.jobfield})) and
{table.pcs} <> 0

-LB

 

[kbrown73]

That's a great help thanks a bunch.