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)

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

Fri, 27 February 2015 05:26

Eclipse User

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

Attachment: example.png
(Size: 7.87KB, Downloaded 94 times)

Re: Count - count's null rows [message #1650357 is a reply to message #1638857]

Wed, 04 March 2015 14:57

Eclipse User

Instead of using COUNT try using COUNTDISTINCT.

Previous Topic:	Page Break does not work in a List Group
Next Topic:	customize the width of each field on the report

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Mar 16 00:05:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter