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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RESET RUNNING TOTAL - MESS!

Status
Not open for further replies.

LMCRYER

Programmer
Jul 30, 2001
388
US
Reset never or on change of group, depending upon your needs. This assumes your only suppression criterion is {table.productionhours} = 0.

I am using CR 9, will also use CE 9 / SecureView (if I ever get the report fixed!)

Issue:

Running total "reset" -- unsure how to achieve desired result

Running total name = 3 ACTUAL DOLLARS
Summarizes formula = @SUM C CUR ACT & PRD ACT
Evalute = val({@PERIOD (CONVERTED)}) > val({@formatted PRD})
Reset = val({@PERIOD (CONVERTED)}) <= val({@formatted PRD})

Bottom line - I need to reset this for EACH GROUP, too.
I need the RESET to be "AND...groupnumber ..??"

Any ideas, guys? This report is huge, running totals all over the place, and it took many hours to get the amounts to come in the right way. I really dont want to redo it in a manual one unless its absolutely necessary....

Help???

LMC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top