Count of addresses
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?