BusinessObjects Board

Creating a variable using not equal to?

building reports desktopintelligence
#1

Hi there,

So I’m trying to create a variable using this statement = Where( Not equal to “ELI”,“RED”,“SAL”)

What is the statement to use for ‘not equal to’. If I use equal to ‘=’ then the error message I get is ‘Syntax Error’ and I think the formula is too long.

Stumped for the time being. :idea: :roll_eyes:

lisachoi (BOB member since 2004-06-24)

#2

Business Objects Reporter operators:

  • NOT
  • InList

for example:

= NOT (<Date> InList  ('05/08/2004', '05/09/2004', '05/10/2004'))

Regarding the WHERE clause in Business Objects Reporter, please see this entry in FAQ Reporter.

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