4 Replies Latest reply on Aug 29, 2018 1:47 PM by Shinichiro Murakami

    Creating an Avg

    Barb Reiser

      Sheet 3 in the attached workbook. I need to create an avg score, using the measure Avg Score, based on Score, ADH Score, QA Score for Care Agents and Score, ADH Score, QA Score, and AOV Score for Sales Agents. I'm not sure how to get it to average. I tried dividing it by 3 and 5 but that doesn't work. They should read as 3.0, 3.8, and 3.2.

       

       

      IF ATTR([Agent LOB]) = "Care Agent" THEN [Score]+[ADH Score]+[QA Score]

      ELSEIF ATTR([Agent LOB]) = "Sales Agent" THEN [Score]+[ADH Score]+[QA Score]+[AOV Score]+[Close Rate Score]

      END

       

       

       

       

       

      Thank you,

      Barb