Forum Discussion

Krobberts's avatar
Krobberts
New Member
3 years ago
Solved

Average function not working

Hello,    I'm having real trouble with the AVERAGE function. I have a column in my data which has a score against a list of people (1-5). I want to average that column of data.    I keep getting ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Krobberts 

    even if the values are showing only digits, still the data type need to be defined as whole or decimal number. Open the query editor and change the data type of the column from general or text to whole or decimal number. 

Krobberts's avatar
Krobberts
New Member
3 years ago

Hi tamerj1 thank you so much! Seems so obvious now you've said that! Really appreciate your support.