Displaying two different work groups in one report?

[surad]

I am Trying to combine two different groups in Number of cases created/average Hourly & Daily & Weekly.


I am having difficulty displaying both Support groups Summary calculation at once. Please advise what might be preventing this. Listed below are functions used in this report.


{TABLE_CASE.CREATION_TIME} = {?Reporting Date} and
{TABLE_EMPLOYEE.WORK_GROUP} IN ["Support-Chap.", "Support-Corp."]

@G1 Avg - Function

IF Count ({TABLE_CASE.ID_NUMBER}, {TABLE_EMPLOYEE.WORK_GROUP})>=1 AND
({@G1Activity Ameerali, Garth}+
{@G1Activity Breedlove, Annette}+
{@G1Activity Byers, Chris}+
{@G1Activity Belachew, Akile}+
{@G1Activity Munoz, Jose}+
{@G1Activity Kelly, Pauline}+
{@G1Activity Nolan, Steve}+
{@G1Activity Nguyen, Andy}+
{@G1Activity Abady, Nielab}+
{@G1Activity Harmon, Clyde}+
{@G1Activity Rodgers, Jean}+
{@G1Activity Sweeney, Glenda})>=1 THEN
(
(Sum ({@Ameerali, Garth}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Breedlove, Annette}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Byers, Christopher}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Belachew, Akile}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Munoz, Jose}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Kelly, Pauline}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Nolan, Steve}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Nguyen, Andy}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Abady, Nielab}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Harmon, Clyde}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Rodgers, Jean}, {TABLE_EMPLOYEE.WORK_GROUP}))+
(Sum ({@Sweeney, Glenda}, {TABLE_EMPLOYEE.WORK_GROUP})))
/
({@G1Activity Ameerali, Garth}+
{@G1Activity Breedlove, Annette}+
{@G1Activity Byers, Chris}+
{@G1Activity Belachew, Akile}+
{@G1Activity Munoz, Jose}+
{@G1Activity Kelly, Pauline}+
{@G1Activity Nolan, Steve}+
{@G1Activity Nguyen, Andy}+
{@G1Activity Abady, Nielab}+
{@G1Activity Harmon, Clyde}+
{@G1Activity Rodgers, Jean}+
{@G1Activity Sweeney, Glenda})
ELSE 0

@G2 Avg - Function:

IF Count ({TABLE_CASE.ID_NUMBER}, {@Sunday}, "daily&quot>=1 AND
({@G2Activity Ameerali, Garth}+
{@G2Activity Breedlove, Annette}+
{@G2Activity Byers, Chris}+
{@G2Activity Belachew, Akile}+
{@G2Activity Munoz, Jose}+
{@G2Activity Kelly, Pauline}+
{@G2Activity Nolan, Steve}+
{@G2Activity Abady, Nielab}+
{@G2Activity Harmon, Clyde}+
{@G2Activity Rodgers, Jean}+
{@G2Activity Sweeney, Gleda})>=1 THEN
Count ({TABLE_CASE.ID_NUMBER}, {@Sunday}, "daily&quot
/
({@G2Activity Ameerali, Garth}+
{@G2Activity Breedlove, Annette}+
{@G2Activity Byers, Chris}+
{@G2Activity Belachew, Akile}+
{@G2Activity Munoz, Jose}+
{@G2Activity Kelly, Pauline}+
{@G2Activity Nolan, Steve}+
{@G2Activity Abady, Nielab}+
{@G2Activity Harmon, Clyde}+
{@G2Activity Rodgers, Jean}+
{@G2Activity Sweeney, Gleda})
ELSE 0

@G3 Avg - Function:

IF Count ({TABLE_CASE.ID_NUMBER}, {TABLE_CASE.CREATION_TIME}, "daily&quot>=1 AND
({@G3Active Kelly, Pauline}+
{@G3Activity Munoz, Jose}+
{@G3Active Nolan, Steve}+
{@G3Activity Ameerali, Garth}+
{@G3Activity Breedlove, Annette}+
{@G3Activity Byers, Chris}+
{@G3Activity Belachew, Akile}+
{@G3Activity Abady, Nielab}+
{@G3Activity Harmon, Clyde}+
{@G3Activity Rodgers, Jean}+
{@G3Activity Sweeney, Glenda})>=1 THEN
Count ({TABLE_CASE.ID_NUMBER}, {TABLE_CASE.CREATION_TIME}, "daily&quot
/
({@G3Active Kelly, Pauline}+
{@G3Activity Munoz, Jose}+
{@G3Active Nolan, Steve}+
{@G3Activity Ameerali, Garth}+
{@G3Activity Breedlove, Annette}+
{@G3Activity Byers, Chris}+
{@G3Activity Belachew, Akile}+
{@G3Activity Abady, Nielab}+
{@G3Activity Harmon, Clyde}+
{@G3Activity Rodgers, Jean}+
{@G3Activity Sweeney, Glenda})
ELSE 0

@G4 - Function:

IF Count ({TABLE_CASE.ID_NUMBER}, {TABLE_CASE.CREATION_TIME}, "by hour&quot>=1 and
({@G4Active Ameerali, Garth}+
{@G4Active Breedlove, Annette}+
{@G4Active Byers, Chris}+
{@G4Active Belachew, Akile}+
{@G4Active Munoz, Jose}+
{@G4Active Kelly, Pauline}+
{@G4Active Nolan, Steve}+
{@G4Active Nguyen, Andy}+
{@G4Active Abadey, Nielab}+
{@G4Active Harmon, Clyde}+
{@G4Active Rodgers, Jean}+
{@G4Active Sweeney, Glenda})>=1 THEN
Count ({TABLE_CASE.ID_NUMBER}, {TABLE_CASE.CREATION_TIME}, "by hour&quot
/
({@G4Active Ameerali, Garth}+
{@G4Active Breedlove, Annette}+
{@G4Active Byers, Chris}+
{@G4Active Belachew, Akile}+
{@G4Active Munoz, Jose}+
{@G4Active Kelly, Pauline}+
{@G4Active Nguyen, Andy}+
{@G4Active Abadey, Nielab}+
{@G4Active Harmon, Clyde}+
{@G4Active Rodgers, Jean}+
{@G4Active Sweeney, Glenda}+
{@G4Active Nolan, Steve})
ELSE 0

Each employee also has the following functions from G1 to G4:

@G1Activity Belachew, Aki - Function

"IIF(Sum ({@Belachew, Akile}, {TABLE_EMPLOYEE.WORK_GROUP})>=1, 1, 0)"

Thank you

 

[synapsevampire]

What does having difficulty mean? Error? Wrong results? Mouse button sticking?

-k

 

[surad]

The problem is summary of calculation is not displaying for both groups simultaneously. Instead, the result of support-corp. shows 0's but provides numbers for support-chap. employees in one week but later shows vice versa on the same week on another page.

Thanks,
Yuri