I prefer WHERE clauses over IF THEN ELSE in Business Objects Reporter, because IF THEN ELSE requires the dimension you are comparing against to be in the block.
Moderator remark:
Please, choose more descriptive topic titles other than “Why won’t this work?! Grrr.” I changed the topic title to “Problem with WHERE and InList”
Uhm, I tried using the If then clause. It didn’t work so I went back to using the Where clause. What would be the correct way of inputting in a ‘not’ in the statement. I need to exclude ELI and RED.
So my original formula is
= Where( Not “ELI” and Not “RED”)
The formula works with a = statement but doesn’t work with a Not statement.