Help

Sum up durations (rollup) from another table with lookups (backloop)

Topic Labels: Data Formulas
Solved
Jump to Solution
920 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ixe
4 - Data Explorer
4 - Data Explorer

Hello

I have three tables

  • CONTRIBUTORS, with Name and other info
  • ACTIVITIES, with Title and other info
  • CONTRIBUTIONS, with Contributor name (lookup), Activity title (lookup) and Duration

The latter looks like

  • Alan, Hackathon A, 12:00
  • Melinda, Hackathon A, 10:00
  • Alan, Presentation C, 4:00

Now, I would like a field Total contributions in CONTRIBUTORS that sums up the Duration of CONTRIBUTIONS per Name. 😊

This would show 16:00 for Alan, 10:00 for Melinda, etc.

I got the result in a pivot table but I need it as a table field.

I tried the following, which does not work. 🤔

Total contributions (rollup) in CONTRIBUTORS
Linked from CONTRIBUTIONS, field Duration, where Contribuor contains {Name}, aggregate SUM(values)

Thank you for your help. 🙂

1 Solution

Accepted Solutions
pressGO_design
10 - Mercury
10 - Mercury

You need to use linked fields, not lookups, to get the results you want. See attached screenshots.

See Solution in Thread

2 Replies 2
pressGO_design
10 - Mercury
10 - Mercury

You need to use linked fields, not lookups, to get the results you want. See attached screenshots.

ixe
4 - Data Explorer
4 - Data Explorer

Ho it was easier than I thought. 😅 Thank you @pressGO_design ! 😺