Skip to Content
0
Former Member
Oct 03, 2013 at 02:28 PM

Not Eqal to Operator for multiple values

15 Views

Hi,

I am trying to exclude some personal areas for ex: 10 and 11 in the webi report. I wrote the below formula.

=If([Personnel Area].[Personnel Area - Key]<>"0010" Or [Personnel Area].[Personnel Area - Key]<>"0011";1;0) and it is not working. If I just do for one value =(If([Personnel Area].[Personnel Area - Key]<>"0042" ;1;0), it works. My datasource is bex query and we are 4.0. Please help me understand why this is not working for more than one value or how to make it work.

Thanks,

Charvi.