I'm currently trying to calculate the number of employees who worked on a particular job. I was able to achieve the result I was looking for using the ExecuteSQL function. However, I'd like to achieve the same result without using the ExecuteSQL function.
I created a summary field (sum_test), which counts the number of WorkerIDs but the problem is that a worker may clock in and out of a job more than one time during the day or pay period. I created a summary field (sum_ListWorkerID) listing the WorkerIDs. The duplicates are a result of clocking in and out. I also created a field to get the unique values , UniqueValues ( List ( sum_ListWorkerID ) which returns a list of all workers whether they worked on the job or not. So I get the following result:
Ultimately, I'd like to achieve the result of 4, the unique values of the summary field, sum_ListWorkerID.
Any help on this would be greatly appreciated.