Hello,
I am trying to create an average based off of letter ratings.
For example, I have a table of individual’s projects which has a column with a grade or rating for that specific project. It can be A, B or C.
In a linked table for the individuals, I have a column which has all their grades/ratings in the one field. So one may just have an A and another may have B,C,B, and another A,A,B,B,A.
I would like to have a formula field which will take the group of grades/ratings for each person and averages them. I don’t care if the result is a letter average or a numeric average.
If I were a teacher, I guess this would be equivalent to getting each students GPA based off of just letter grade entries.
Each formula i try, i get an error…I feel like i’m missing something very obvious.
Thank you!
