2 Replies Latest reply: Feb 3, 2016 10:42 PM by Srikanth P RSS

    Calculate difference to Total average expression

      NameSkillAvg ScoreDifference against total averageAbove/Below
      2.82How do I make this column?

      Name 1

      12.50=2.82-2.50 (Column should show 0.32)Above
      Name 223=2.82-3 (Column should show -0.18)Below
      Name 313=2.82-3 (Column should show -0.18)Below
      Name 422.80=2.82-2.80 (Column should show 0.02)Above

       

       

       

      Im struggling on how to calculate the above.

       

      I would also like to know that if I was to add conditions in set analysis i.e. Skill = 1 only if I would have to do it differently.

       

       

      Best,

       

      Mav