Eclipse Community Forums: BIRT » Count

Home » Archived » BIRT » Count - count's null rows(My row count is counting null rows when I only want it to count not null rows)

Show: Today's Messages :: Show Polls :: Message Navigator

Count - count's null rows [message #1638857]

Fri, 27 February 2015 10:26

kate fryatt

Messages: 3
Registered: February 2015

Junior Member

I'm trying to count how many user's are in the rows in my table - however some of the data is duplicated. I suppressed the duplicate data but when I do a aggregate COUNT it returns all of the rows as it counts them regardless of whether they are blank or not.

Is there a way of counting my user ID's but not the duplicated ones that I have suppressed? I tried filtering but it still appeared to count it.

(As you can see in the image it says user: 11 when in there's only 4 users the rest have been suppressed as they were duplicate)

Thanks -
Kate