AnsweredAssumed Answered

Sum of Filtered Portal Records

Question asked by DavidConrad on Jun 22, 2011
Latest reply on Jul 8, 2011 by Corné

Title

Sum of Filtered Portal Records

Post

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

Outcomes