I am very new to this forum and this App, so please, use 4th grade english if possible.
If I were creating something like a movie rating survey where each record had a rating (1-5) and I wanted to see the average that all respondants gave for each movie, how would I do that?
Example: 5 forms were returned to create 5 records. D-Day was one movie that each respondant rated. Record 1 gave it a 5, Record 2,3,4 gave it a 4 and record 5 gave it a 3. Each record has a field called Average which gives a rating of 4 since it is the average of 5,4,4,4,3.
I assume that the Field 'Average' is a calculation and I have found the 'Sum' formula but it only works on each record individually not accross all records.
Thanks in advance.
