I am developing an APP for a community of businesses which includes business (of course) and the public who will spend at the businesses.
When the public spends they will key in the amount spent and the business name they spent at.
So i have a sheet of users that include the business name and a sheet to track all the spending. That is spending is recorded one spending per row. User fill up data using form button.
By going to data editor and creating a relation between the name of receiving business and the business name in the user sheet, I can find out the business receiving’s user email.
With this user email, i can filter all the transactions received by the signed in user.
For example, company A receives on three different occasions $20, $15 and $$15. I can these transactions using inline list and filtering according to signed in user.
Now my question is: how do I get the total amount? i.e. add all three to = $50?
I hope you understand what I am trying to say and help to respond.