Use number(s) from Single Select in calculation formula to average the score

[B_Michael_69]

I want to create a AVERAGE formula using 3 columns that use the single select function. See attached image.

[kuovonne · Accepted solution]

Welcome to the Airtable community!

Even though the single select values look like numbers, they are not numbers to Airtable. You need to convert them to number in your formula.

AVERAGE(
  VALUE({Evaluator 1 score}),
  VALUE({Evaluator 2 score}),
  VALUE({Evaluator 3 score})
)

You will also probably want to adjust the formatting options for the formula field to show the number of decimal places you want.