6 Replies Latest reply: Jan 22, 2015 12:17 AM by vikas mahajan RSS

    Cummulative Graph

      Hi All,

       

      Any suggestion how to show cumulative calculation  ?

       

      Problem Statement

      • I have database which has all active and exit headcount details corresponding to each month.

       

      I am using this formula to calculate average attrition for eachmonth  : Count(Exit)/(Count(Active)/Count(Distinct MONTH))

       

      Now i need to show cummulative attrition percenatge for each month i.e. For the month of Feburary attrition will be :

       

      ( Total Exit in January and February ) / Average( Headcount in January and February)

       

      Similarly for March :

       

      Total Exit in January ,February & March  )/ Average( Headcount in January ,February & March )

       

      Thanks

      Anurag Gupta