# How to conduct formulas for reports? I need help with this case

**URL:** <https://community.glideapps.com/t/how-to-conduct-formulas-for-reports-i-need-help-with-this-case/40000>\
**Category:** Ask for Help\
**Created:** [March 23, 2022, 3:54pm UTC](https://community.glideapps.com/t/how-to-conduct-formulas-for-reports-i-need-help-with-this-case/40000 "2022-03-23T15:54:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![habao213](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/habao213/32/33067_2.png) [@habao213](https://community.glideapps.com/u/habao213)\
**Post date:** [March 23, 2022, 3:54pm UTC](https://community.glideapps.com/t/how-to-conduct-formulas-for-reports-i-need-help-with-this-case/40000/1 "2022-03-23T15:54:35Z")

</div>

Hi, I want to do a report on the Glide app but I feel difficult to apply statistics.  
For example:  
I created a voting form. After Users voted with some criteria, I want to do some statistics report such as the average point of criterion A, criterion B,…

 ![report](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/2569f0d4ee43b641fc9fc2dba3c63d6835916cf7.png)  
So, I need to sum all the rows with “Mã Showcase = 3”, “Same Date”, and "Tên Showcase= TDTasks). How can I do that?  
Please help!  
Thanks.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 23, 2022, 6:25pm UTC](https://community.glideapps.com/t/how-to-conduct-formulas-for-reports-i-need-help-with-this-case/40000/2 "2022-03-23T18:25:12Z")

</div>

Create a template column that joins your three column values together.  
Then create a multiple relation column that links the template column back to itself.  
Then use a rollup column to get the average of whichever column you need through the relation.

---

<div class="post-metadata">

**Author:** ![habao213](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/habao213/32/33067_2.png) [@habao213](https://community.glideapps.com/u/habao213)\
**Post date:** [March 24, 2022, 11:40am UTC](https://community.glideapps.com/t/how-to-conduct-formulas-for-reports-i-need-help-with-this-case/40000/3 "2022-03-24T11:40:55Z")

</div>

Thank you so much, Jeff. I dit it.  
Have a nice day

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 25, 2022, 11:41am UTC](https://community.glideapps.com/t/how-to-conduct-formulas-for-reports-i-need-help-with-this-case/40000/4 "2022-03-25T11:41:43Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.