Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Calculating counts of groups

edited December 2002 in End User
Hi,

I, for the life of me, cant get the following to work:

I have 3 groups lets call them Employees within Classification within
Department. There is a booking table which is the detail line. Now I want
to perform a count on how many detail lines there were at each group level.
I can achieve this no problem. Where I am having a problem is counting how
many employees worked on those bookings. So at classification group I want
to say that 5 employees made up the 20 bookings within the calssification.

As an example:

Class Emps Shifts Average

A 10 54 5.4
B 15 60 4.0
C 8 64 8.0

Its the emp column total I am having problems with. I have tried counts,
tried a calc field increasing the value by 1 each time it gets to group
footer and other things to no avail. Any help or direction appreciated

Regards

Alex

Comments

  • edited December 2002
    Ok forget it :) I worked it out, staring me in the face as usual.

    Alex

This discussion has been closed.