How to calculate opening and closing head count of employees

[sunitha_chellaiah]

Hi All

I want to calculate opening headcount of employees and closing headcount of employees. I have data as shown below

LOAD 
EMPID,
EMPLOYEE,
LOCATION,
FUNCTION,
POSITION,
DOJ,
DOL,
FROM
.......................;

 formula to calculate the opening and closing are given below

Opening balance = closing of the last month

Hiring = Current month joining

Leaving = Current month Leaving

Closing Balance= Opening + Hiring-leaving

can someone help me to achieve this requirement

[sunitha_chellaiah]

Hi @Henric_Cronström  Sir, Can you please help me to solve this.

[Agnes92]

Many organizations do use a form of average headcount in their calculations. Instead of taking the beginning or start of year, they will take the EOP Headcount for each employee for each month and average across the year.

skylightpaycard