# Rollup average of scores submitted by the user **URL:** \ **Category:** Ask for Help\ **Created:** [March 19, 2024, 2:37am UTC](https://community.glideapps.com/t/rollup-average-of-scores-submitted-by-the-user/71784 "2024-03-19T02:37:47Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![MikeFox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikefox/32/72381_2.png) [@MikeFox](https://community.glideapps.com/u/MikeFox)\ **Post date:** [March 19, 2024, 2:37am UTC](https://community.glideapps.com/t/rollup-average-of-scores-submitted-by-the-user/71784/1 "2024-03-19T02:37:47Z")
Hey there. I need help. Video: [ Daily Score App · Glide - 19 March 2024 - Watch Video ](https://www.loom.com/share/62b777ebe50b43b28e8c788a79ff2263)[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc338df11686277a4c65fcada74464290056f3dc.gif)](https://www.loom.com/share/62b777ebe50b43b28e8c788a79ff2263) In the app, the user submits an entry for the day, gives it a score, and outlines some activities of the day. I want to be able to show a rolled up average to the user for all of their submitted entries, NOT for all submitted entries by all users. How do I make this happen? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 19, 2024, 2:47am UTC](https://community.glideapps.com/t/rollup-average-of-scores-submitted-by-the-user/71784/2 "2024-03-19T02:47:28Z")
- Create a multiple relation column in your Users table that matches each user email with the same value in the Date Entries table - Do your rollups through that relation NB: I see you already have a relation column in your Users table, but it appears to be a single relation. You can’t do rollups through that. ---
**Author:** ![MikeFox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikefox/32/72381_2.png) [@MikeFox](https://community.glideapps.com/u/MikeFox)\ **Post date:** [March 19, 2024, 3:17am UTC](https://community.glideapps.com/t/rollup-average-of-scores-submitted-by-the-user/71784/3 "2024-03-19T03:17:56Z")
Thanks @Darren_Murphy [ Rollup average of scores submitted by the user - Ask for Help - Glide Community - 19 March 2024 - Watch Video ](https://www.loom.com/share/34363605528d432981f8107e15e65bc5)[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b0516bc97dccdd6dadbf4d191528503701516267.gif)](https://www.loom.com/share/34363605528d432981f8107e15e65bc5) I already had that, but now I’m not sure what I’ve got to change - I thought it was already matching multiple, but chances are I’ve pointed it to the wrong place. Appreciate your help! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 19, 2024, 3:23am UTC](https://community.glideapps.com/t/rollup-average-of-scores-submitted-by-the-user/71784/4 "2024-03-19T03:23:54Z")
Yes, your relation is correct (after you adjusted it). Ignore the Lookup - that’s not required or relevant. I suspect it’s the Rollup that is the problem - check and make sure it is referencing the values directly via the relation, and not via the table. If you can’t get it to work, show me a screen shot of the rollup configuration. ---
**Author:** ![MikeFox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikefox/32/72381_2.png) [@MikeFox](https://community.glideapps.com/u/MikeFox)\ **Post date:** [March 19, 2024, 9:56am UTC](https://community.glideapps.com/t/rollup-average-of-scores-submitted-by-the-user/71784/5 "2024-03-19T09:56:35Z")
Solved, thanks @Darren_Alderman!! I removed the other computed columns and modified the rollup to look at the right relation and it’s sorted. Really appreciate the assist! ---
**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 26, 2024, 9:57am UTC](https://community.glideapps.com/t/rollup-average-of-scores-submitted-by-the-user/71784/6 "2024-03-26T09:57:32Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.