2 Replies Latest reply: May 4, 2017 7:37 AM by Hugo Wortel RSS

    How to calculate the average of different fields with incidental null values??

    Hugo Wortel

      Hi!

       

      I have a table with 7 fields (columns) which correspond to questions in a survey. It's a bit like this:

       

      1. To what extent do you agree with [statement 1]?

      2. To what extent do you agree with [statement 2]?

      3. To what extent do you agree with [statement 3]?

      ...

      7. To what extent do you agree with [statement 7]?

       

       

      The possible values ("the scores") for each field range from 1 to 5, but null values ("N/A") also occur. I would like to calculate the average of these fields per row. That means I have to sum the values and divide them by the number of fields which do not have a null value.

       

      What would be the best solution?

       

      Thanks!