Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Data Formulas
Solved
Jump to Solution
1829 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 ! 😺