Hi,
I am trying to get the count of employees that belong to a particular department. Given that an employee can belong to different departments, the count of employees needs to accurate and each employee needs to accounted only once. Each employee needs to be counted only once.
The information is currently stored on 0EMPLOYEE and there is a separate employee number for each record for an employee in a department. So if an employee belongs to three departments, he has three different numbers, but a unique ID for all the three records. In the report, how can I ensure that an employee is only counted once?
Thanks,
Raj