Skip to main content
I have a custom object "EnrollmentSummary" that has a master detail relationship with the account object.

 

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 respostas
  1. 15 de nov. de 2017, 17:17
    @Steve Molis

     

    Hi Steve, your solution worked like magic. I really needed a way to sum up my cases  in the report.