I’m a rose breeder, and I’m creating an app to track my pollinations. I’m trying to find a way to create a sum of numbers from a list of referenced items.
Currently, I have 3 tables. Roses, Crosses, and Daily Pollinations. I have each of these reference each other. Currently, whenever I create an item/row in the Daily Pollinations table, I select a Cross and add the number of pollinations for that day. Then, that set of daily pollinations shows up in a list in the Crosses table.
I want to find a way to summarize the total number of pollinations for that cross. For example, if I did 20 pollinations the May 1st and I did 30 pollinations May 2nd, there would be two items. I want to a new column with the combined total of 50.
Hope that makes sense. I’ve been trying to find a way to do this, but I’m still learning all the formulas.
Thanks in advance!