Count() by CASE

[clrblue]

I am trying to get a count of unique employee ID numbers for those employees who not only work

at a specific site, but whom also have an AM work schedule. In the employees file, I have all of

their personal info as well as their expected regular schedules. So, I developed the following

CASE statement, trying to get the count (Monday AM is the field that holds each employee's Monday arrival time):

CASE (

Site = "Austin" and Monday AM > 0, Count(Employee ID),

Site = "Rochester" and Monday AM > 0, Count(Employee ID),

Site = "San Francisco" and Monday AM > 0, Count(Employee ID),

Site = "Nashville" and Monday AM > 0, Count(Employee ID),

""

)

---

I placed the field in the Sub-Summary field of my report where I had grouped the report by site.

All I received was a count of the first instance of the calc that made it true... so all counts are

"1". This is inaccurate. How can I make it count all instances of the statements?

TIA,

KC

[Kurt Knippel]

You have 2 problems. One is that only Summary field will calculate in the way you are expecting in a sub-summary part, normal field will simply calculate based on a single record. Second is that the CASE statment will only evaluate ONE of those conditions.

"sCount = Count of EmployeeID" is the way to setup a summary field. This will then count the employees in whatever sub-summary you put this field in.

[clrblue]

Cool. Thanks, Kurt.