# Summing up by group

**URL:** https://community.glideapps.com/t/summing-up-by-group/70869
**Category:** Ask for Help
**Created:** [February 16, 2024, 3:31am UTC](https://community.glideapps.com/t/summing-up-by-group/70869 "2024-02-16T03:31:13Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)
#### Post date: [February 16, 2024, 3:31am UTC](https://community.glideapps.com/t/summing-up-by-group/70869/1 "2024-02-16T03:31:13Z")

</div>

I have a table of PO elements.

I create a PO and then I add items to that PO.  
I have a table that has rows of items and which PO they are linked to, I want to calculate the total value of a PO, how do I do it.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/3/03e02182113c0ff7ce943bda2dc3e423427c05fe.png)

I wan to do some something like rollup or group by “PurchaseOrderNo” but then I wan to do a SUM on the TotalPrice and put it into a column called POTotal

---

<div class="post-metadata">

### 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: [February 16, 2024, 3:43am UTC](https://community.glideapps.com/t/summing-up-by-group/70869/2 "2024-02-16T03:43:49Z")

</div>

In your PO Table, create a multiple relation that matches each PO with the associated rows in the PO Items table. Then do a rollup-\>sum of the total price through that relation.

---

<div class="post-metadata">

### Author: ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)
#### Post date: [February 16, 2024, 4:08am UTC](https://community.glideapps.com/t/summing-up-by-group/70869/3 "2024-02-16T04:08:13Z")

</div>

🤯 🤯 🤯 It works, now I just need to decipher it so I can apply in other scenarios.

Thank you…

---

<div class="post-metadata">

### 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: [February 16, 2024, 4:14am UTC](https://community.glideapps.com/t/summing-up-by-group/70869/4 "2024-02-16T04:14:08Z")

</div>

Just for future reference, if you need to match multiple conditions, use a query column instead of a relation.

---

<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: [February 23, 2024, 4:14am UTC](https://community.glideapps.com/t/summing-up-by-group/70869/5 "2024-02-23T04:14:52Z")

</div>

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