Forum Discussion
AVERAGE function error
The values in your screenshot are left-aligned. This makes me suspect that they are text values, not real numbers.
Select the range.
Make sure that the number format is set to General or to Number, not to Text.
On the Data tab of the ribbon, click Text to Columns, then click Finish.
Alternatively, change your average formula to
=AVERAGE(--Table_0[Goals GF/GP])
The values in your screenshot are left-aligned. This makes me suspect that they are text values, not real numbers.
Select the range.
Make sure that the number format is set to General or to Number, not to Text.
On the Data tab of the ribbon, click Text to Columns, then click Finish.
Alternatively, change your average formula to
=AVERAGE(--Table_0[Goals GF/GP])
Now I notice that when the table updates, all the table settings go to default and the Average function will not working anymore.
Is it possible to auto update the values without changing the table settings?
Thank you!
- Thank you!
The key was that Text to Columns. I just tried to set the number format from the Home tab only.
