How to get things in database to add (as in finding the sum of)

[samuelphillips10]

I have 3 fields, Amount, TaxRelief, Reference with Amount and TaxRelief as numbers and Reference as text. What I am looking to do is add the Amount values up and also the TaxRelief values up if the Reference matches. For example the image above should end up like this:

Thanks in advance

[BrianHenderson]

You’ll want to make a repeating group with this data and then use the “:group by” for your Reference field. Then use an aggregation Sum for the number values.

https://manual.bubble.io/core-resources/data/operations-and-comparisons#group-by

[samuelphillips10]

Thanks, it works perfectly!