# Sum total time from the value for individual rows from a table

**URL:** <https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685>\
**Category:** Ask for Help\
**Created:** [July 8, 2024, 12:19am UTC](https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685 "2024-07-08T00:19:21Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [July 8, 2024, 12:19am UTC](https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685/1 "2024-07-08T00:19:22Z")

</div>

I have a list of steps in table one, each step has a duration

I have a “lesson” which includes various steps from table 1.

e.g. lesson 1, includes steps 1, 2 and 4. durations are 5, 10, and 15 respectively.  
lesson 2 includes steps 1,3 and 5. durations are 1,2 and 3.

I would like to rollup these durations into a total time column for each lesson.  
Lesson 1 = 30  
Lesson 2 = 6.

Basic approach appreciated.  
thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 8, 2024, 1:02am UTC](https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685/2 "2024-07-08T01:02:22Z")

</div>

- Create a multiple relation from your lesson table to your steps table.
- Create a rollup on top of that relation, using the “sum” method and point to the durations column.

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [July 8, 2024, 1:29pm UTC](https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685/3 "2024-07-08T13:29:35Z")

</div>

I got this working but I had to create a lookup that pulled back the durations of the related steps and then summed these together.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 8, 2024, 1:44pm UTC](https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685/4 "2024-07-08T13:44:20Z")

</div>

You don’t have to do the lookup part. A rollup should work directly using the relation as its source.

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [July 8, 2024, 6:21pm UTC](https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685/5 "2024-07-08T18:21:41Z")

</div>

When I did it without lookup every row added up all the step durations. Using lookup allowed me to add the unique durations for each lesson

---

<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:** [July 8, 2024, 7:30pm UTC](https://community.glideapps.com/t/sum-total-time-from-the-value-for-individual-rows-from-a-table/74685/6 "2024-07-08T19:30:13Z")

</div>

If the Rollup is summing all rows, that means you are pointing it to the entire table when you should be pointing it to the relation instead. Rollups absolutely do not require a Lookup in between to work.