Forum Academy Marketplace Showcase Pricing Features

Adding to create total discounts

User 1 uploads a transaction report to our database that contains a list of transactions which is linked to a list of Users when uploaded. Each transaction contains a discount. I am trying to figure out how to add the total discounts that is linked to a user. Anyone know how to add values from data fields to create a total?

See if this makes sense:

And look for the aggregation called “sum”

Do i need to remove the “$” in order for that to function? if so how do i extract it? is there a regex code for that?