how to find average employee count for a particular month ?

[nishanthi_8]

how to find average employee count for a particular month ?

[Gysbert_Wassenaar]

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.

[#3]

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: 

(Hours_worked + Hours_accrued)/ 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?

[Anonymous]

Count(distinct EmpID)

/

No. Of Month

[sunny_talwar]

Or may be this:

Dimension

MonthYear

Expression

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