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 )



      Anurag Gupta