1 2 3 Previous Next 31 Replies Latest reply on May 1, 2019 10:58 AM by San M

    Calculation for year over year performance

    San M

      Hello,

       

      I am trying to get to a formula where i can get to see year over year performance based on the associate ratings over years. Basically, i want to know best formula to derive the count of people whose rating went up, went down or remained the same.

       

      An example is below for your reference.

        

      NameReview FormOverall RatingRemarks
      AFY1651st rating
      AFY174went down
      AFY185went up
      AFY193went down
      BFY1761st rating
      BFY184went down
      BFY195went up
      CFY1821st rating
      CFY195went up

       

      Thanks

      San

        1 2 3 Previous Next