Average of numeric field

[Ipsita]

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

[Ipsita]

Yes, I skipped Null values and changed to float.

Thanks and Regards,

Ipsita

[Anil_Babu_Samineni]

Can you please share sample real data set