Link to home
Start Free TrialLog in
Avatar of jph826
jph826

asked on

Rolling average number of active employees

CRV10 - I need to write a report showing a rolling average number of active employees for current year.  I'm thinking I  need formulas for nbr active first day of month, nbr active last day of month and average nbr for the month.  Then somehow I need to have a rolling average.  So if Jan there were 100 active employees the avg would be 100.  If Feb there were 75 active employees on the last day, then the rolling average would be 100 + 75 divided by 2 = 87.5 and so on.  I'm thinking the end result would look something like this:
Avg Emps:  end of Jan    end of Feb    end of Mar   end of Apr ......
It needs to be current year only.  My fields are {EMPLOYEE_DATE_HIRED} and {EMPLOYEE_DATE_TERMED}.
The report will be auto run and emailed monthly so I can't use parameters.  I would appreciate your recommendations.
ASKER CERTIFIED SOLUTION
Avatar of frodoman
frodoman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jph826
jph826

ASKER

Thank you both.  If I use a count employee formula, how would the rolling average fit in each month?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Glad i could help

mlmcc