Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 10:26 Go to next message
kate fryatt is currently offline kate fryattFriend
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 -
  • Attachment: example.png
    (Size: 7.87KB, Downloaded 86 times)
Re: Count - count's null rows [message #1650357 is a reply to message #1638857] Wed, 04 March 2015 19:57 Go to previous message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
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:

Current Time: Tue Jul 23 03:59:34 GMT 2024

Powered by FUDForum. Page generated in 0.03461 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top