Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to calculate Avg head count for Quarter.
Actual Head count:
Q1 7256
Q2 7553
Q3 7599
Q4 7699
Average head count:
Q1 6807
EX: Q1=Apr,May,Jun
6681 +6759+6981=20421/3= 6807
Thanks,
Krishna
Have you intended to attach a QVW that contains some Emp ID data?
I think your current attachments does only show a master calendar, please recheck.
Maybe you can use something like
=Count([Emp. Id]) / Count(DISTINCT Month)
or
=Avg( Aggr(Count(DISTINCT [Emp. Id]), Month))
depending on how your emp table is built.
He has posted the same discussion multiple times, you can find a correct version of the qvw here: Calculate AVG Head count
Ok, thanks for the info, Sunny.
Then please just close this thread (if you want, as ASSUMED ANSWERED), krishna4bo, and try to avoid posting multiple times the same request.
It's just a waste of time for all, as you see here.