Calculate Average Across Multiple Columns and rows

masonicmartin · 2024-07-24T17:04:31.979Z

Hi everyone! I’m having a difficult time calculating average across multiple columns and rows in my DB. Here is my current DB set up:

Columns

Column 1 = Student_Name
Column 2 = Question_1_Score (a numerical value 1-5)
Column 3 = Question_3_Score (a numerical value 1-5)

Rows

each student can have multiple rows because the same questions will be answered weekly. For example:
John Smith | 2 | 5
John Smith | 3 | 1
John Smith | 1 | 4

I’m trying to calculate each student’s score across all of their respective entries, which spans multiple rows and columns. I am attempting to do this via a repeating group.

Any help would be appreciated! Thank you

GaryIreland · 2024-07-24T17:49:06.461Z

you can have an option set on the page of type number and have a “when page is loaded” workflow that sets it. Put the calculation in that workflow. All the current users scores divided by the number of scores. Then you can reference it in a repeating group or wherever you want.

You could also do that option set as a list if you wanted multiple users average scores.

You might consider just working this calculation into whatever workflow records their individual scores and have it update the average each time. Then its saved in the database where it sounds like you want it.