2 Replies Latest reply: May 2, 2016 11:54 AM by Sunny Talwar RSS

    Average Multiple Variables in Script

    Isabelle Timmermans

      Hi,

       

      I have multiple score-variables and i want to make an average. It can be done with set analysis, but i have my reasons why i want it in the script. Anyone knows how to do that?

       

      I have this:

       

      NameScore 1Score 2Score 3Score 4Score 5
      A7591
      B2953
      C59
      D576
      E4

       

      And i want this:

      NameAverage Score
      A5.5
      B4.8
      C7
      D6
      E4

       

      I tried AVG(Score 1, score 2, score 3, score 4, score 5) but it doesn't work.

       

      Thanks,

      Isabelle