Sum of list 2's values, referencing list 1's item#

ryan23 · 2024-09-04T07:34:03.123Z

Ok so I have two lists saved within the DB:
List of texts
List of numbers

I have an RG displaying the list of texts.
What I’m looking to do is reference ‘current cell’s text’ within the ‘list of texts’ and sum the value of each individual text’s corresponding value in list 1 (using it’s item# within the list).

Can anyone help please?

animisha45 · 2024-09-04T07:36:28.786Z

Are the lists linked to each other in any way? If yes, :group by on list 1 should work.
If they are not linked, first try to establish a relation between them.