How to count number of active employees by month

  • 0
  • 1
  • Question
  • Updated 1 month ago
I have an integration coming in from our time tracking system. Where each employee can have many time cards in a month. I am looking to find how many employees or a count of employees by month. that have labor hours >0 and not recount each time card. 

I have a summary report created and thought i could do a calculated field that concatenates the employee number, month and year. then if they have more than one record in any given month or year, count them as 1. otherwise 0?

The formula below is not working though and is still counting all records. Can this be done or is there a better way?
Thanks

Count(

If(Count(List("","","",[Employee Number],ToText([Month No]),ToText([Year No])))>1,1,0)

)









Photo of Rob Salaj

Rob Salaj

  • 120 Points 100 badge 2x thumb

Posted 1 month ago

  • 0
  • 1

Be the first to post a reply!