Discussion Board for collaboration related to QlikView App Development.
I want to calculate opening headcount of employees and closing headcount of employees. I have data as shown below
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
Hi @Henric_Cronström Sir, Can you please help me to solve this.
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.