Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove suppressed values from running total 2

Status
Not open for further replies.

kpetree

IS-IT--Management
Feb 11, 2010
7
0
0
US
I have a suppression formula on the detail row that looks like this...

Previous({mctrxhst_sql.ord_no})={mctrxhst_sql.ord_no} and
Previous({mccrwhst_sql.oper_no})={mccrwhst_sql.oper_no} and
Previous({mctrxhst_sql.trx_dt})={mctrxhst_sql.trx_dt} and
Previous({mctrxhst_sql.lbr_hrs})={mctrxhst_sql.lbr_hrs}

How can I remove the suppressed rows from a running total?

Thank You!
 
You would have to enter the opposite of the suppression criteria in the formula area for the evaluation section of the running total. You could try adding your current formula and wrapping it in: not()

-LB
 
lbass, you are awesome, thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top