Count the number of employees in a group.

Lani Vriezema
Lani Vriezema used Ask the Experts™
on
Hello,

I created a date range parameter and grouped the data by employees. My goal is to count the number of employees who worked during a time period. I tried using the count formula for the employee group but it won't let me. Please help
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
What period do you want them counted for?

If it is the entire period of the date range just use

     DistinctCount({EmployeeID})

Since you grouped by employee there is only 1 employee in each group.

mlmcc
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet Software

Commented:
Sounds like you grouped by X (employee) but you want to count by Y (e.g. by Day).

You can simply insert a CrossTab grouped by Y.
For more complex cases, you can use a subreport grouped by Y.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial