# Sum list calculated values

**URL:** <https://forum.adalo.com/t/sum-list-calculated-values/27150>\
**Category:** Get Help\
**Created:** [May 12, 2022, 8:28pm UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150 "2022-05-12T20:28:19Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![oswaldoguerra27](https://avatars.discourse-cdn.com/v4/letter/o/7feea3/32.png) [@oswaldoguerra27](https://forum.adalo.com/u/oswaldoguerra27)\
**Post date:** [May 12, 2022, 8:28pm UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150/1 "2022-05-12T20:28:19Z")

</div>

My question is simple. I got a Jobs collection on wich I have Area and Price per Area fields.  
I am showing both fields on a list and I am also showing a text with the Job Amount (that is Area x Price).  
Is there a way to calculate the total amount? I mean sum the field that is calculated on each list row without putting it as a collection field?

---

<div class="post-metadata">

**Author:** ![Rozza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rozza/32/22780_2.png) [@Rozza](https://forum.adalo.com/u/Rozza)\
**Post date:** [May 12, 2022, 9:45pm UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150/2 "2022-05-12T21:45:50Z")

</div>

edit - sorry misread your post.  
Yes, under the list place some text and add some magic text.  
Find the field you need in the magic text menu and choose SUM.

---

<div class="post-metadata">

**Author:** ![oswaldoguerra27](https://avatars.discourse-cdn.com/v4/letter/o/7feea3/32.png) [@oswaldoguerra27](https://forum.adalo.com/u/oswaldoguerra27)\
**Post date:** [May 12, 2022, 10:09pm UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150/3 "2022-05-12T22:09:38Z")

</div>

I think you did not understand or I did not explain well. What I am trying to sum is not a collection field but its a list item.

---

<div class="post-metadata">

**Author:** ![Rozza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rozza/32/22780_2.png) [@Rozza](https://forum.adalo.com/u/Rozza)\
**Post date:** [May 13, 2022, 8:22am UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150/4 "2022-05-13T08:22:01Z")

</div>

Hi @oswaldoguerra27

Yeah a magic text outside the list will work. In the text element use a ‘Custom Formula’, then reference the fields you want to sum and multiply them together. Look for this menu in magic text for SUM function (it appears against any number field).

 ![Screenshot 2022-05-13 at 09.10.05](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/0/6/0620c8f30d429a47b8c7a4f712fe9a0ec3acc477.png)

Example formula

 ![Screenshot 2022-05-13 at 09.18.22](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/e/2/e2d72f3542a7ebcbf3866a71f62ca216c6fa36f8.png)

I believe if you want to go deeper than 3 relationships then the functionality is limited, with no sum or avg. My guess is that this is to preserve resources and performance. In which case your menu will have 3 options. Like I said before, you might be better storing the multiplication when the record is created and doing a simple SUM outside of the list, rather than doing it when the list is loaded.

![Screenshot 2022-05-13 at 09.11.03](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/f/3/f3a8e24bd75f302580bec603902ede19579e8cee.png)

---

<div class="post-metadata">

**Author:** ![oswaldoguerra27](https://avatars.discourse-cdn.com/v4/letter/o/7feea3/32.png) [@oswaldoguerra27](https://forum.adalo.com/u/oswaldoguerra27)\
**Post date:** [May 13, 2022, 1:10pm UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150/5 "2022-05-13T13:10:04Z")

</div>

Hi @Rozza !  
Thanks for your patience!  
I am sending a screenshot.  
As you can see, the values in the list depends on the two inputs outside the list. Thats why I cannot store it in a collection.  
Sorry about my english.

This is how my list looks like:

 ![Screen Shot 2022-05-13 at 10.06.50](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/5/9/59cccea7e9f424d8222daf256c5bad13b12d3179.png)

---

<div class="post-metadata">

**Author:** ![Rozza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rozza/32/22780_2.png) [@Rozza](https://forum.adalo.com/u/Rozza)\
**Post date:** [May 13, 2022, 3:26pm UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150/6 "2022-05-13T15:26:31Z")

</div>

No worries,  
the formula option is down at the bottom. Check this screenshot

 ![Screenshot 2022-05-13 at 16.24.52](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/b/0/b0a358a9cd5b566ce6cb3b5a483ae8dad5921027.png)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [May 23, 2022, 3:26pm UTC](https://forum.adalo.com/t/sum-list-calculated-values/27150/7 "2022-05-23T15:26:49Z")

</div>

Closed on May 23, 2022, 3:26pm UTC

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