BusinessObjects Board

What's wrong with this variable??

building reports desktopintelligence
#1

I have a variable that works fine like this:

PendCount=0+Count( , <Param List ID(Personnel Monitoring Data)>) Where (= “Y”)

however when I change the criteria after the where clause to

<> “Y” I get a syntax error.

why do I get an error when I change “=” to “<>”?

I only want it to count when the FinalReleaseFlag is NOT equal to Y

any help would be appreciated

vendus (BOB member since 2009-10-09)

#2

Try this:

PendCount=0+Count(<Sample ID> , <Param List ID(Personnel Monitoring Data)>) Where (Not(<Finalreleaseflag>)= "Y")

I am however picking that this is not the full formula, if this doesn’t work, it might pay to paste the entire formula.

plessiusa :netherlands: (BOB member since 2004-03-22)

#3

thanks for the suggestion, but I still get a Syntax Error (DMB0007) when I try it with “Not”

vendus (BOB member since 2009-10-09)

#4

Do you want to paste your entire variable so that I can have a better look.

Thanks,

plessiusa :netherlands: (BOB member since 2004-03-22)

#5

The where clause can only work with = and a constant value. If you need something more flexible, please see this entry in the FAQ. Thanks.

Dave Rathbun :us: (BOB member since 2002-06-06)

#6

Thanks Dave.

I am fairly new at Desktop Int. this restriction on the where clause seems so retarded (for lack of better term)

thanks again!

vendus (BOB member since 2009-10-09)

#7

This is only one of the little quirks that you will experience with the tool. Regardless, it is still very good at what it does so long as you work within its limits.

plessiusa :netherlands: (BOB member since 2004-03-22)