11 Replies Latest reply: Aug 17, 2017 10:03 AM by Anil Babu Samineni RSS

    Average of numeric field

    Ipsita Mahapatra

      Hello,

       

      Can anyone please help me in calculating the average of below shown column. It is strange why QS is not able to calculate the average of a number field. I am using SQL server for data connection and uploading to QS Desktop via Data Manager. All the Null values are from Database table.

      I can only able to calculate the count of the 'Rating' by giving the expression Count(Rating) as measures in KPI visualization.

      If i will use excel data sheet for the same column then it is able to calculate average but not for my Data connection.

      Capture.PNG

      Any help/suggestion is highly appreciated.

       

      Regards,

      Ipsita