Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rastogi_vinayak
Contributor II
Contributor II

Calculating an attrition rate ?

Hello Everyone,

How to calculating an Attrition Rate ?

Please give an Idea for expression 
Formula – (total no. of employees exited in that Financial Year/ Average no. of employees
in that Financial Year * 100).
Formula for Average no. of employee – (Total no. of employees every month / 12).

for Data Overview Please find the Attachment.

Thank you 

Labels (1)
3 Replies
Anil_Babu_Samineni

What do you mean by "Financial Year"
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rastogi_vinayak
Contributor II
Contributor II
Author

Hi @Anil_Babu_Samineni,

 if your financial year is from 1 April 2018 to 31 March 2019, then it is known as FY 2018-19.

Anil_Babu_Samineni

Check this?

(Count({<[Financial Year] = {$(=Max([Financial Year]))}>} employee) / ((Count(TOTAL <Month> employee)/12)*100))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful