AnsweredAssumed Answered

Sum of Filtered Portal Records

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


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