Hello!
I have created a report that contains employee records. An employee can show up twice on the report if they have regular and overtime.
Example:
Emp No Hours Type
100 40 Reg
100 2 OT
102 40 Reg
At the bottom of the report, I would like to display how many employees are on the report, not the record count. Is there a way to do a Count(Distinct(EmpNo))???
Thank you in advance!
I have created a report that contains employee records. An employee can show up twice on the report if they have regular and overtime.
Example:
Emp No Hours Type
100 40 Reg
100 2 OT
102 40 Reg
At the bottom of the report, I would like to display how many employees are on the report, not the record count. Is there a way to do a Count(Distinct(EmpNo))???
Thank you in advance!