Summing item #s in list of numbers

Need help Database
1

I have a list of things which each have a list of numbers. The numbers are the thing’s value for different years.

I want to sum up the totals for each year across the list of things but I can’t figure out a way to do it.

For example, I can only get “Search for things: each item’s numbers item #7”. When what I want is “Search for thing: each item’s numbers: item #7 :sum” It just will not let me add the sum.

Does anyone know how to achieve this? /get around the problem without having to restructure the datatype? Or is restructuring the datatype the only way.

2

yup, just use a server script and write a function that takes in a list of numbers and sums them…

you’ll need to declare an empty list variable and empty number variable, and then send in your list of numbers from bubble as the list, and then return the empty number.