Hi AppSheet community. I need some help please for an App i've built for a charity I volunteer for.
We utilise the AppSheet database function and within it we have some tables. The tables of interest here are the: "Donor Master Data" table and "Donations" table. The Donor Master Data table has a unique Supporter ID for each donor, including their name etc. The Donations table is a transaction listing of all amounts received by the charity. There is a column called "Payment Amount" which is the amount received. This could include donations as well as payments for retreats. There is a column called "Receipt Type" which flags whether it's a donation or payment for a retreat etc
We would like a view which lists all donors and all their lifetime donations only. I.e. we want to exclude the payment made for retreats from this view.
Please can you help us figure this out? We've tried to add a Virtual Column with the following expression but it returns nil:
SUM(SELECT(Donations[Payment Amount], AND([Supporter ID]=[_THISROW].[Supporter ID], [Receipt Type]= "Donation")))
The view is pointing to the Donor Master Data table.
Appreciate your time looking into this.
A
LinkedIn
Twitter
