Calculate AVG Head count

[Anonymous]

   Hi All,

How to calculate AVG Head count for all Quarters.

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

[sunny_talwar]

Can you reload the application and reattach? The attached application doesn't seem to have Emp ID field in it

[Anonymous]

Hi Sunny ,

I reattached.

Thanks,

Krishna

[sunny_talwar · Accepted solution]

Try this expression:

=Avg(Aggr(Count(DISTINCT([Emp. Id])), Month))

[Chanty4u]

chk dis

Average – Which average?