4 Replies Latest reply: Sep 2, 2016 7:03 AM by Steve K

# how to find average employee count for a particular month ?

how to find average employee count for a particular month ?

• ###### Re: how to find average employee count for a particular month ?

Count the number of employees at the beginning of the month and at the end of the month. Sum those two counts and divide the result by two.

• ###### Re: how to find average employee count for a particular month ?

Depends what you're trying to do.  If you're trying to get an FTE count that matches what accounting does, then you have to use accrued hours to get the right calculation.  The formula is:

(Hoursworked + Hoursaccrued)/ days in the month/(days in the year/7)*40

It's a little complicated to get it to work in qlik but doable.  Is this what you're trying to do?

• ###### Re: how to find average employee count for a particular month ?

Count(distinct EmpID)

/

No. Of Month

• ###### Re: how to find average employee count for a particular month ?

Or may be this:

Dimension

MonthYear

Expression

Sum(Aggr(Count(DISTINCT EmpID), Date))/Day(MonthEnd(MonthYear))