Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Any help/suggestion is highly appreciated.
Regards,
Ipsita
Yes, I skipped Null values and changed to float.
Thanks and Regards,
Ipsita
Can you please share sample real data set