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

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

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.

Thanks, it works perfectly!

1 Like