Cannot calculate Sub-Total

[1994mkiv]

Posting the pic for better answer.

As you can see the report is grouped by week then Dept then Employee ID. The second column is subtotal of the employee hours for the whole week. I used the function for the third column to calculate the over time which is

If sum({employee.payhour}, “weekly”)>40 then (sum({employee.payhour}, “weekly”)-40)
Else sum({employee.payhour}, “weekly”)

Now I need to do the subtotal by dept. calculating the employee.payhour was easy and used the built-in subtotal function. The overtime is not even an option there. So first thing I did was write another function sum(@overtime, “employee.dept”) it gave me a error stating the running total cannot be calculated. When I looked at the option for running total @overtime is not even listed there either. Can somebody tell me how can I get the subtotal of overtime by dept.

 

[dgillz]

This is the classic 3 formula approach using variables.

First initialize the variable in the date group header:

WhilePrintingRecords;
If Not InRepeatedGroupHeader then Numbervar OTSub:=0;

In the employeeID group footer, you accumulate the OT:

WhilePrintingRecords;
Numbervar OTSub:=OTSub+{@overtime};

In the employeeID group footer, you display it:

WhilePrintingRecords;
Numbervar OTSub;

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

Your overtime formula is missing the group condition, and should default to 0 I think:

If sum({employee.payhour}, {employee.date},“weekly”)>40 then
sum({employee.payhour},{employee.date}, “weekly”)-40 else
0
...although maybe you just posted the formula incorrectly.

-LB