BusinessObjects Board

Not in operator

building reports desktopintelligence
#1

Hi guys,
Need your help.

I am creating DESKI report where i have to write forumla that give me count of products where type not equal to Book.
I have to create variable as
=sum()where( <> “Book”)
But issue is as soon as i write

=sum()where(, after this i dont see any other operator except = OR See list of Values. I am not sure why <> is not showing up.
I am trying different way as welL:
=If(<>“Books”) then sum(), it throuws computational error.
Thing is in this case i see operator <> but not in above case.

Any help guys how to resolve this?

Thanks.

karan_aries (BOB member since 2005-02-17)

#2

With Deski you can only use = in an “In” clause and then only when compared to a dimension object. The easiest way to solve your question is you remove the <> calculation and put it in another variable.

You can see an example in the Reporter FAQ in this post. :slight_smile:

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

#3

Thanks that worked. :stuck_out_tongue:

karan_aries (BOB member since 2005-02-17)