Calculate Employee Work Days? Accumulate unique employees per day

[General Ledger]

Looking for a way to calculate employee work days. It is the sum of distinct employees for each day in a file of transactions.

The file has all the transactions (each with a date and time stamp) entered by every employee.

If on a single day an employee posts one transaction, then I know that employee worked. That is 1 employee day.
If on a single day an employee posts ten transactions, then I know that employee worked. This is still 1 employee day.
If on a single day ten employees post any number of transactions, that is ten employee days.
If one employee posts one transaction each day for five days, that is five employee days.
If ten employees each post at least one transaction each per day for five days, that is 50 employee days.

My ultimate goal is to calculate sales per employee day. If I can calculate how many employees worked each day, add them up for a time period (week, month, etc.), I can calculates sales per employee days worked. This is a better measure than sales per week or sales per month because the number of employees working on a given day fluctuates.

Thanks,

G/L

 

[scottsen]

Not quite the same, but see if this gets you going in the right direction?
Two methods to calculate Person-Hours | Tiny Lizard

 

[PentaGalCXO]

Could it be as simple as creating a calculated column [eday] = [employee] & [Day], then defining a measure of distinctcount([eday]) ???