11 Replies Latest reply on Jul 18, 2017 12:20 AM by Anne Renaudeau

    Calculate evolution between two years

    Anne Renaudeau

      Hi !

       

      I have data like that :

      DATE Number of employees
      12-20161048
      01-2017

      1050

      02-20171024
      03-20171036
      04-20171054
      05-20171054
      06-20171035
      07-20171056
      08-20171058
      09-20171024
      10-20171058
      11-20171056
      12-20171055

       

      I would like to see the turnover beetween :

           - 12-2016 and 12-2017

       

      To have :

      2016-122017-12
      Number of employee10481055
      Turnover-leaver / ((1048 + 1055)/2)

       

      How can I recover the data of the last year in the calculation ?

       

      Thanks,

       

      Anne