You tried to execute a query that does not include the specified expression

[FEILynn]

I am trying to write a query that will provide the average of 5 columns. Here is my query, but each time I try to run it I get this error:

You tried to execute a query that does not include the specified expression 'Proposal #' as part of aggregate.

Average Rating: Avg([Eval #1 Overall Rating]+[Eval #2 Overall]+[Eval #3 Overall]+[Eval #4 Overall]+[Eval #5 Overall])

My fields are:
proposal #
offeror name
course name
instructor/offeror
eval #5 overal
eval #1 overall rating
eval #2 overall
eval #3 overall
eval #4 overall
evals provided

What am I doing wrong??

[NeoPa]

The average function aggregates across records and not across fields.

You need to add the values together and divide by the number of columns (5).