How do you count duplicate rows

building reports desktopintelligence
1

I’m using BO 5.0.1. I need to know what function to use on counting the duplicate information in a column. When I am using the Count , Count(Count(object), or CountAll, it does not include the duplicate items.

Khanh Dang
AirTouch Cellular

Listserv Archives (BOB member since 2002-06-25)

2

Khanh Dang,
Try using “=NumberOfRows(DataProvider())” without the quotes. . where “Seq Number” is any object contained in your query. This has always worked for me. This counts the number of rows returned by the query so if you are using a filter, you’ll have to use some other formula.

Roger Poole
rpoole@nswc.navy.mil

I’m using BO 5.0.1. I need to know what function to use on counting the duplicate information in a column. When I am using the Count , Count(Count(object), or CountAll, it does not include the duplicate items.

Khanh Dang
AirTouch Cellular

Listserv Archives (BOB member since 2002-06-25)

3

I thought with 5.0x there was a Count All option, does that sound familiar?

Brent

Khanh Dang,
Try using “=NumberOfRows(DataProvider())” without the quotes. . where “Seq Number” is any object contained in
your query. This has always worked for me. This counts the number of rows returned by the query so if you are using a filter,
you’ll have to use some other formula.

Roger Poole

I’m using BO 5.0.1. I need to know what function to use on counting the
duplicate information in a column. When I am using the Count , Count(Count(object), or CountAll, it does not include the duplicate items.

Khanh Dang

Listserv Archives (BOB member since 2002-06-25)