Group 2 summary totals in Group 1 Footer ?

[AussieLad]

Probably a simple answer, but help ! (This is as brief as I could be, sorry)...
I need to produce a report showing our fortnightly salary info grouped by month, (ie, Grp2), for each employee, (ie, Grp 1). Simple enough.
Further though, I also have to EXCLUDE any 'Months', (Grp2), if the sum of the salary for a month is below say $600. [I used the 'Group Selection' criteria to exclude these, eg, Sum ({Salary}, {Pay_Ending}, "monthly&quot >= 600].

My query is... "How do I get the sum of the monthly salary, (Grp2), as a total for each employee, (Grp1), when I run the report spanning multiple months, and prevent the "less-than-$600-month" totals from being summed in Grp 1?"
(Note that if I use 'Sum of Salary' in GF1, it INCLUDES the "less-than-$600-month" Grp 2 totals, even though they don't print/display... again, we don't want these totalled !)

Layout is as follows...
GH1= {Emp_ID} (Suppressed)
GH2= {Pay_Ending} (Suppressed) [n.b. Section printed 'for each month']
Details = {Salary} (Suppressed)
GF2= {Pay_Ending}, (showing Month, "08/2003&quot, Sum of Salary
GF1={Emp_ID}, {Name}, <This is where I want the sum of the Monthly Salaries, excluding the &quot;less-than-$600&quot; months>

Hope this all makes sense.

 

[Madawc]

In Crystal 8.5, you should be able to do a Running Total with the $600 limit as a formula rule.

Madawc Williams
East Anglia, Great Britain

 

[tomerotem]

hi
yuo need to make 3 formula

formoula 1

whileprintingrecords;
numbervar total;
total := 0


formula2
whileprintingrecords;
numbervar total;
total = total + (gruop2) {Pay_Ending} ;


formula3
whileprintingrecords;
numbervar total;
total ;


formula 1 you put on gruop 1
this formul rest the amount to 0 when the gruop cenge

formula 2 you put on gruop 2
this formula runnig total amount

formula 3 you put on gruop 2
this formula show the true amount

yosi
éåñé ùéðãìø

 

[AussieLad]

Appreciate your help, Madawc and Tomerotum.

I used Madawc's suggestion.

Many thanks !