How to enter a filter expression Not in?

[Shoji Kaburagi]

Hello,

I am trying to create a report that filters anything BUT the list of values. I can create one that includes list of values as this:

=Fields.USER_LOCATION In =Split("|", "BH-0019|BH-0030|BH-0019")

But how can not create a filter that filters anything BUT the list of values?

Any help is appreciated.

Thanks!

[Stef]

Hi Shoji,

Test to create an expression evaluating to a Boolean e.g.:
Expression: =Fields.USER_LOCATION Not In Split("|", "BH-0019|BH-0030|BH-0019")
Operator: Equal(=)
Value: =True

For more details check our Operators help article.

I hope this helps you.

Regards,
Stef
Telerik

[Shoji Kaburagi]

It works. Thanks!

[Shoji Kaburagi]

Sorry to bother you again, but how do I enter a string value if one of values contains a double-quotes ex BH-135|AB"C|BH-035?

[Stef]

Hi Shoji,

Please refer to the Note and further details in the Expressions Constants help article.

Regards,
Stef
Telerik

[Shoji Kaburagi]

Got it

Thanks!