BusinessObjects Board

Using more than one argument in "Where" function..

building reports desktopintelligence
#1

Hi all,

This is a wonderful forum and thanks to all that contribute.

I have a query where i am trying count two different values i.e. Hub (RBS) Site and Hub (MTX) Site.

I am using the following BObj statement to achieve this:

=Count() Where (=“Hub (RBS) Site”)

However this only counts the “Hub (RBS) Site”; and i would like to add another argument onto this Count like so:

=Count() Where ((=“Hub (RBS) Site”) And (=“Hub (MTX) Site”))

I have tried this however, it comes up with a Syntax error…

What am i doing wrong? Or am i using the incorrect condition statement?

Using ver. 6.1b

Any help is appreciated.
TIA

deepblue (BOB member since 2006-02-27)

#2

Try a similar approach found in this FAQ.

Andreas :de: (BOB member since 2002-06-20)

#3

Thanks!

That works a dream :yesnod:

deepblue (BOB member since 2006-02-27)