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

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.

  • 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.
1 Like

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.

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

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

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.

1 Like