# Question about calculating average
**URL:** https://community.glideapps.com/t/question-about-calculating-average/42952
**Category:** Ask for Help
**Created:** [June 10, 2022, 7:43pm UTC](https://community.glideapps.com/t/question-about-calculating-average/42952 "2022-06-10T19:43:01Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Alvis\_Lo](https://community.glideapps.com/u/Alvis_Lo)
#### Post date: [June 10, 2022, 7:43pm UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/1 "2022-06-10T19:43:01Z")
In my case, I need to calculate the average test result of my students. They did the testing 5 time, but som of them just did 4.
If I set the Math as (test1+ test2+ test3+ test4+ test5)/5, for those students who did 5 test the answer is correct, but for those students who did4, it surely wrong, how can I set the Math which can fit both?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 10, 2022, 9:39pm UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/2 "2022-06-10T21:39:08Z")
The problem isn’t the math column, the problem is choosing dividing by 4 or 5, correct?
What I recommend is using the Make Array column instead of a math column. Select each of the 5 scores as an item in the array. Then use a rollup column → average that’s sourced from the Make Array column.
---
### Author:  [@justinjmp](https://community.glideapps.com/u/justinjmp)
#### Post date: [June 10, 2022, 9:39pm UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/3 "2022-06-10T21:39:48Z")
Hi Alvis,
Can you try:
1. Creating a relation of your students with their test scores
2. Doing a lookup on their scores
3. Doing a roll up count on their scores to find what to average by
4. Using a math column to average their test scores by the count of how many tests they have completed?
This should give you what you are looking for.
---
### Author:  [@justinjmp](https://community.glideapps.com/u/justinjmp)
#### Post date: [June 10, 2022, 9:40pm UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/4 "2022-06-10T21:40:35Z")
Much easier way of doing it!
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 10, 2022, 10:24pm UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/5 "2022-06-10T22:24:26Z")
This is how the Robert’s suggestion is going to look like
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 11, 2022, 1:54am UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/6 "2022-06-11T01:54:29Z")
Exactly. Love the Make Array column 😉
@David_Gabler
---
### Author:  [@Alvis\_Lo](https://community.glideapps.com/u/Alvis_Lo)
#### Post date: [June 11, 2022, 6:28am UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/7 "2022-06-11T06:28:26Z")
Thanks for your great example… it’s very helpful 👍
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [June 12, 2022, 6:28am UTC](https://community.glideapps.com/t/question-about-calculating-average/42952/8 "2022-06-12T06:28:35Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.