topic Re: How to calculate the average of different fields with incidental null values?? in App Development https://community.qlik.com/t5/App-Development/How-to-calculate-the-average-of-different-fields-with-incidental/m-p/1364065#M30711 <HTML><HEAD></HEAD><BODY><P>Yes!</P><P></P><P>You're first solution is what I was looking for. The second one requires a fixed number (7) of fields, but because of the null values some fields don't count.</P><P></P><P>Thank you, Sunny!</P></BODY></HTML> Thu, 04 May 2017 11:37:43 GMT 2017-05-04T11:37:43Z How to calculate the average of different fields with incidental null values?? https://community.qlik.com/t5/App-Development/How-to-calculate-the-average-of-different-fields-with-incidental/m-p/1364063#M30709 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have a table with 7 fields (columns) which correspond to questions in a survey. It's a bit like this:</P><P></P><P>1. To what extent do you agree with [statement 1]?</P><P>2. To what extent do you agree with [statement 2]?</P><P>3. To what extent do you agree with [statement 3]?</P><P>...</P><P>7. To what extent do you agree with [statement 7]?</P><P></P><P></P><P>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 <EM>which </EM><EM>do not have a null value.</EM></P><P></P><P>What would be the best solution?</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 04 May 2017 09:37:09 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-the-average-of-different-fields-with-incidental/m-p/1364063#M30709 2017-05-04T09:37:09Z Re: How to calculate the average of different fields with incidental null values?? https://community.qlik.com/t5/App-Development/How-to-calculate-the-average-of-different-fields-with-incidental/m-p/1364064#M30710 <HTML><HEAD></HEAD><BODY><P>You can use RangeAvg() or RangeSum() which ignore text and null values</P><P><STRONG>RangeAvg(Field1, Field2, Field3, Field4,.... Field7) as Avg</STRONG></P><P></P><P>or</P><P><SPAN style="font-size: 13.3333px;"><STRONG>RangeSum(Field1, Field2, Field3, Field4,.... Field7)/7 as Avg</STRONG></SPAN></P></BODY></HTML> Thu, 04 May 2017 11:18:03 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-the-average-of-different-fields-with-incidental/m-p/1364064#M30710 sunny_talwar 2017-05-04T11:18:03Z Re: How to calculate the average of different fields with incidental null values?? https://community.qlik.com/t5/App-Development/How-to-calculate-the-average-of-different-fields-with-incidental/m-p/1364065#M30711 <HTML><HEAD></HEAD><BODY><P>Yes!</P><P></P><P>You're first solution is what I was looking for. The second one requires a fixed number (7) of fields, but because of the null values some fields don't count.</P><P></P><P>Thank you, Sunny!</P></BODY></HTML> Thu, 04 May 2017 11:37:43 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-the-average-of-different-fields-with-incidental/m-p/1364065#M30711 2017-05-04T11:37:43Z