How to build a list of any individuals who have given at least $100 for at least the last 7 fiscal years. Right now I have a list of anyone who has given a gift every year for the last 7 fiscal years, and at least $100 for any of those years, but not $100+ for each of those years 7 years... This is a specific example, but any kind of list where we need multpile seasons AND an amount in each of those seasons would be good to know how to pull.
Contribution Fund HAS IndividualContribution Fiscal Year HAS 2005/06Contribution Fiscal Year HAS 2006/07Contribution Fiscal Year HAS 2007/08Contribution Fiscal Year HAS 2008/09Contribution Fiscal Year HAS 2009/10Contribution Fiscal Year HAS 2010/11Contribution Fiscal Year HAS 2011/12Contribution Amount >= $100.00Thanks,Heather
Marisa’s suggestion to build multiple lists and then a list of everyone who is on each of those lists is probably the easiest solution. You might be able to do this with a manual edit to the code in a single criteria set, but that would require some SQL knowledge. Using an extraction really wouldn’t help in this case, as each segment is effectively joined by OR not AND.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com