I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to AF_2011 after 5/1/2010 to date, but gave to no other Annual Funds (AF_2010 and below.) My results continue to include those who gave to previous Annual Funds.
Software/Hardware used: Crystal Reports 8.5, iMIS 10.6 Windows SQL server