report variable (BO XI) that excludes diplicate rows

building reports webintelligence
1

I need to create a variable that returns a count excluding duplicate rows of data.  Basically, I have a report that contains the following data:

Project  Project Type Equipment #
ABC SR 12345
ABC SR 12345
ABC SR 54321
 
I need to create a variable that captures the distinct “Equpment #” count by Project.  So, I want to return the value 2 instead of 3.  Also, the combination of “Project,” “Project Type,” and “Equipment #” is what makes the row unique.

Thanks.

sloth66 (BOB member since 2009-07-22)

2 
=Count([Project]+[Project_Type]+[Equipment_#]; DISTINCT)

should do it.