Problem with WHERE and InList

building reports desktopintelligence
5

You have to create a helper variable as pointed out in this FAQ Reporter entry I linked to.

Helper variable (data type boolean):

= NOT ( <REASON>InList ("ELI", "RED") )

Then:

= <measure> WHERE ( <Helper variable> = 1)

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