Calculating Average Value Across Records

[mkucsak]

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.

[LiveOak]

I would create two related files. A file for "Movie" and a file for "Survey". The Movie file is related to it's subset of surveys by a RecordID (Movie Number). The average scores for this move can then be calculated by:

AverageScore (calculation, number) = Sum(RelToScores::Score) / Count(RelToScores::Score)

Scores can be entered in the Movie file in a way that automatically creates new records in the Survey by 1) setting the relationship to "allow creation of related records" and using a portal to enter the new scores. Place the appropriate related fields in the portal row (say respondent and score). Clicking on the blank portal row and entering information will automatically create a records in the Survey file.

Oh, to be clear on the relationship, create a field in Movies:

RecordID (number, auto enter serial number, prohibit modification)

Create a field in Survey:

MovieID (number)

Create a relationship in Movie with RecordID on the left side and MovieID on the right side (of the dialog).

-bd