Sum of Filtered Portal Records
Warning: Novice Question:
My main table is a list of donors, the related table contains a list of donations. I have a portal on my layout showing the donations, each record in the donations table has "Gift_date" and "Gift_amount" fields.
I want to calculate and display the total giving between two specified dates: e.g. Total gifts for the last year, the last five years etc.
It was easy to create a field and calculate the total of all the gifts for a single donor, I just can't figure out how to filter the gift records so I can add up only the gifts received between specified dates for a donor.
Thanks for the help