There can be multiple EnrollmentSummary Records for one Account for a specific year. We also have at least one record for each year going back to 2009.
I want to create a report that tells me how many accounts had a specific enrollmentsummary field for each of the last 3 years.
The problem is that if I can't just use the account because I need historical data (2009, 2010 and 2011) and when I include the enrollmentsummary object, I now get counts based on the number of records in Enrollmentsummary and not counts based on unique accounts... (for example, account "Test" has 2 EnrollmentSummary records for 2011... I only want to count Test once as its only one account for 2011
Any help would be greatly appreciated!!!
Fred
18 réponses
@Steve Molis
Hi Steve, your solution worked like magic. I really needed a way to sum up my cases in the report.