don't count hidden duplicates

S

Sarah

In my report, I have hidden duplicates in my "Description" field. I want to
count the number of occurrences of each unique description and am able to do
this using

=-sum([Description]="description name")

However, I don't want to count the hidden duplicates, but they are showing
up in the sum value. Is there a way to get around this?

Thanks!
Sarah
 
Top