Attiration Formula RRS feed

  • Question

  • Hi,

    I need to calculate Attiration percentage as per the below formula in power pivot, pls help me in doing so.

    Attrition%=(No. of Employees Quit) divided by (Avg. Employees during that time frame) multiplied by 100.

    Thanks in Advance


    Saturday, August 18, 2012 5:53 PM


  • Hello Kiran,

    Actually the Attrition Rate is calculated by the formula

    ATTRITION RATE = ((No. Of EmployeesQuit x 100) / (Actual Employees + NewlyJoined)) /100

    Let Us Say I have a Table for Attrition Details Table Name is "Attiraion" (Forgive for Spelling Mistake)

    Now Create a Linked table, The Below Image shows the Attrition rate Formula


    The Formula for CurrentEMpCount is =(Attiration[TotalEmp]+Attiration[NewJoinees])-Attiration[EmployeesQuit]

    Hope It Helps.



    Saturday, September 8, 2012 12:45 PM