Set Analysis For Month

[kevbrown]

Hi,

Easy question but I've had a mental block.  I'm looking to find out the current number of employees I have and I don't want that to change no matter what selections on date is made. The field I have are CalMonth, CalYear, CalDay, Person ID and Leaving Date. So Leaving date must be null and I need to count distinct Person ID

Thanks

Kev

[MK_QSL · Accepted solution]

=COUNT(

     {<

          CalMonth=, CalYear=, CalDay=, [Leaving Date] =,

          [Person ID] = {"=Len(Trim([Leaving Date]))=0"}

     >}

     Distinct [Person ID])

[kevbrown]

That worked, thanks, however I've had a rethink.

I think what I need to know is how many current employees there are at a certain date. So Leaving date must be null or greater than the date selected in the calendar and Starting date must be less than the date selected

[MK_QSL]

If you have another question, would be better if you raise another thread with example or sample data.