# Sum a repeating group

**URL:** <https://forum.bubble.io/t/sum-a-repeating-group/232008>\
**Category:** Need help\
**Created:** [November 10, 2022, 8:34pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008 "2022-11-10T20:34:25Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![paulgbray](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@paulgbray](https://forum.bubble.io/u/paulgbray)\
**Post date:** [November 10, 2022, 8:34pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/1 "2022-11-10T20:34:25Z")

</div>

Im stuck…  
Can anyone advise on how to calculate the totals of each line of a repeating group?  
I have a drinks pre-order form:  
Drink Name… Drink Price x Items ordered = Total - Ive figured this bit out  
However I cant sum up multiple totals to give a full amount due  
Probably really easy - can you help?  
Cheers  
Paul

---

<div class="post-metadata">

**Author:** ![champion96](https://avatars.discourse-cdn.com/v4/letter/c/bbce88/32.png) [@champion96](https://forum.bubble.io/u/champion96)\
**Post date:** [November 10, 2022, 8:50pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/2 "2022-11-10T20:50:42Z")

</div>

Repeating groups list of items each items products price:sum

I think this above should do it

I’m pretty new but this should calculate total cost of all the items

---

<div class="post-metadata">

**Author:** ![karamwise](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/karamwise/32/130206_2.png) [@karamwise](https://forum.bubble.io/u/karamwise)\
**Post date:** [November 11, 2022, 8:58am UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/3 "2022-11-11T08:58:45Z")

</div>

Hi @paulgbray

Here is the solution for your problem… You can get the sum of item from each line of a repeating group by this method as shown in the screenshot.(Note the total data type must be in number the database).

Total showed in the screenshot is a simple group in which text element has been placed

 ![screenshot](https://us1.discourse-cdn.com/bubble/original/3X/f/f/ff81641e762f1625fed67627c734e2ba79524826.jpeg)

---

<div class="post-metadata">

**Author:** ![paulgbray](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@paulgbray](https://forum.bubble.io/u/paulgbray)\
**Post date:** [November 11, 2022, 11:12pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/4 "2022-11-11T23:12:44Z")

</div>

Hi,  
Thank you v much for the replies… I think I need to revisit my data structure… i’ll revert back with either success or a request for more help!!! ;0)  
Cheers  
Paul

---

<div class="post-metadata">

**Author:** ![karamwise](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/karamwise/32/130206_2.png) [@karamwise](https://forum.bubble.io/u/karamwise)\
**Post date:** [November 14, 2022, 9:55am UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/5 "2022-11-14T09:55:30Z")

</div>

No Problem @paulgbray 😇  
If any further assistance is needed you can connect with me on LinkedIn  
Here is my profile link:- [https://www.linkedin.com/in/karamjitsinghwaldi/](https://www.linkedin.com/in/karamjitsinghwaldi/)

---

<div class="post-metadata">

**Author:** ![paulgbray](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@paulgbray](https://forum.bubble.io/u/paulgbray)\
**Post date:** [November 15, 2022, 3:02pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/6 "2022-11-15T15:02:07Z")

</div>

Hi,  
I really appreciate your help… still cant get it to work!  
Attached is a pic of the repeating group… I’m trying to total the amounts in the right so that the total appears at the bottom (Highlighted)  
Cheers  
Paul

 ![Repeating Group](https://us1.discourse-cdn.com/bubble/original/3X/1/6/1650ca83f4fe3e70e0b826d8a9edbaea6be3c537.jpeg)

---

<div class="post-metadata">

**Author:** ![paulgbray](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@paulgbray](https://forum.bubble.io/u/paulgbray)\
**Post date:** [November 15, 2022, 3:03pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/7 "2022-11-15T15:03:41Z")

</div>

![Repeating Group 1](https://us1.discourse-cdn.com/bubble/original/3X/3/9/39dc674d697be250bc3aa5aeb7791574a65031c7.jpeg)

---

<div class="post-metadata">

**Author:** ![bubbledeveloper1](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubbledeveloper1/32/165302_2.png) [@bubbledeveloper1](https://forum.bubble.io/u/bubbledeveloper1)\
**Post date:** [November 15, 2022, 3:30pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/8 "2022-11-15T15:30:17Z")

</div>

please use sum instead of count ex. each item’s price: **sum**

---

<div class="post-metadata">

**Author:** ![paulgbray](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@paulgbray](https://forum.bubble.io/u/paulgbray)\
**Post date:** [November 16, 2022, 6:59pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/9 "2022-11-16T18:59:54Z")

</div>

The single greatest feeling ever…  
Finally getting the workflow working after 2 weeks of trial and error…  
Thank you for your help people…  
annnndddd… breathe!  
Cheers  
Paul

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [January 19, 2023, 8:34pm UTC](https://forum.bubble.io/t/sum-a-repeating-group/232008/10 "2023-01-19T20:34:37Z")

</div>

This topic was automatically closed after 70 days. New replies are no longer allowed.
