Average

[learning_codes]

Hi,

I'm able to run the number of employees by Month and Division

Year Division Month Actual Count
2006 Accounting January 325
2006 Accounting February 326
2006 Accounting March 324
..... so on
same as Purchasing, Payroll, etc

.......I tried to figure it out but I don't know if I did the right
thing. See below:

I'm trying to get two results but I would appreciate your help:
1) "Average Count" by All Division in 2006
2) "Average Count" by Division in 2006

I create..... Average Count: AVG(Count([EmployeeID])) ....... Is this
correct ?

Year Division Average Count
2006 Accounting 325
2006 Purchasing 950
2006 Payroll 100
2006 Human Resources 10

How do I create all divisions into one Average Count (all Divisions)

Thanks

 

[Guest]

Hi

The built in AVG will automatically calculate total / number of entries.

When you group by division that is ok as you have 1 entry per month so AVG
will divide by 12 (or how many months there are).

By only grouping at the year level AVG will divide by (divisions * months)
as that is how many entries there are instead of dividing by 12.

So you need to calculate your own average like this...

SUM(Count([EmployeeID])) / 12

If you want this to work for any number of months (part years) then you will
first need to build a query to count the months.

Post back if you need more info

Regards

Andy Hull