Running Total based on Formula in Group Footer

Crewdawg

I am using CR10 on a SQL2000 Server via OBDC.
I am creating a summary for a payroll report which summarizes total hours as well as how many of those hours were regular or overtime.

The report is grouped by Employee Code (as in Intials, also user name in DB). I have a running total which adds all of the hours that are applicable to that user code. I then use a fomrula to determine if the #RT is over 40 hours and if it is report 40 hours in Regular Hours column. Then anything over 40 is displayed in Overtime column.

I need to create a Running Total (or sum of) how many hours were regular and how many overtime for the Reoort Footer.

Here are my formulas. For some reason the totals do not add up.

Code:

//1Accum
whileprintingrecords;
numbervar reg1 := reg1 + {@1RegHours};
numbervar ot1 := ot1 + {@1OverHours};
numbervar reg2 := reg2 + {@2RegHours};
numbervar ot2 := ot2 + {@2OverHours};
numbervar totreg := totreg + {@ToTReg};
numbervar totot := totot + {@TotOT};

Code:

//1TotOT (All output formulas are the same except for appropriate variable names)
whileprintingrecords;
numbervar ot1;

sybot_uk · Posted: Thu Nov 22, 2007 3:26 am Post subject:

Hi there, i'm not quite sure what you mean by the sums at the bottom. Where did the 82+82 come from?

One thing you could check for it your group selection. Do you have a formula in the group selection expert? If you do this could be the cause as (i think) any exlcuded groups may still be included in the sums. The same is true if you are using a suppression formula one of the groups.

Just a thought, maybe it will help.

JamesJ · Posted: Wed Nov 28, 2007 6:14 pm Post subject:

Umm, if you'll notice, that message was posted over a year and a half ago. I doubt that he's still looking for help at this point. :-)

James

djayatosu · Posted: Thu Nov 29, 2007 3:51 pm Post subject:

Crewdawg · Posted: Mon Dec 03, 2007 8:06 am Post subject:

I am no longer watching this thread. To satisfy your curiosity the 82 came from the week 1 toatl plus week 2 total.
_________________
----------------------------------------------------
Multithreading is just one thing after, before, or simultaneous with another.