AnsweredAssumed Answered

Count of addresses

Question asked by KurtSnow on Jun 6, 2013
Latest reply on Jun 10, 2013 by philmodjunk

Title

Count of addresses

Post

     I need to count the unique addresses in a found set in my radio company database. A company may have more than one radio station at the address.

     I created a field called "GetAddress" = Count ( MediaCompany::physicalAddress )

     Then a summary field = Total of GetAddress

     I created a report that has a sub-summary of address. The unqiue addresses show up correctly, but instead of 8 in the summary filed, it counts 10 since there are two companies with two radio stations at the same address.

     What am I doing wrong?

Outcomes