calculate Avg head count for Quarter

[Anonymous]

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

[swuehl]

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.

[sunny_talwar]

He has posted the same discussion multiple times, you can find a correct version of the qvw here: Calculate AVG Head count

[swuehl]

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.