AVERAGE with enum

[ltjbsa]

HI - I'm building a player evaluation app for my non-profit little league. There are two tables, players (the name of each player and associated info), and evaluations (holds the score as evaluated by multiple users, which are coaches). Here are the tables:

I would like to store the averages of each evaluation category in the Player table, so that I can display it on the Player detail card. The following formula works as a SELECT, but when I wrap it in AVERAGE it returns an error:

I believe this is because I am using an ENUM list as the form input (to make it easy on the coaches - they can just 'tap' the number while on the field). But i could be wrong, I have only been working with AppSheet for about a week. 

Am I correct in assuming this error is because my input field is ENUM? And if yes, is there a way to work with the inputs of an ENUM as if they were actual numbers in a list? Thank you in advance. 

[Aurelien · Accepted solution]

Hi @ltjbsa 

1) I would suggest change column type for Player ID, from Number to Ref.

2) if you click on the black pen attached to [baserunning] column, can you make sure the input base is Decimal and not Text?

3) After operating step1 and step2, what about:

AVERAGE(
  SPLIT(
    CONCATENATE([Related evaluationss][Baserunning]),
     " , "
  )
)

or

AVERAGE([Related evaluationss][Baserunning])