Charity donation app, bring in lifetime donations per donor

[AmitDev]

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

[Markus_Malessa]

I don't see a problem with your formula, so that is somewhat odd. Is the field for this formula returning an empty value or 0? I'm guessing the app editor is not flagging the formula for an error of any sort?

[AmitDev]

Yep, empty value and no error in the expression.

[Markus_Malessa]

If you don't mind sharing a screenshot for each table from the data section, maybe there is something we are overlooking.

[AmitDev]

Hi, I’m currently on my phone so don’t seem to be able to post a screen shot.

I can tell you though that the total donations column works which just brings in all the donations, unfiltered. But  the column I’m actually looking for is with the expression I posted returns no value, I.e lifetime donate filtered on donations only.

[Markus_Malessa]

If you can update later with screenshots that would help. Also include the 'view' you are talking about. Just want to eliminate some potential misunderstandings.

[AmitDev]

Above is how the Lifetime Donations come through. As you can see the fields are coming through with no values.

[Markus_Malessa]

Try something for me just to see if it works:

SUM(SELECT([Related Donations][Payment Amount], AND([Supporter ID]=[_THISROW].[Supporter ID], [Receipt Type]= "Donation")))

[AmitDev]

Thanks for the tip. Unfortunately it did not resolve the issue, it’s still blank.