Forum Discussion
admin11
Memorable Member
Memorable MemberHow t modify the expression to from include to exclude ?
Hi All
Below expression working fine , which filter 3 number from GL Table base on Document No. field :-
_delete =
SWITCH(
TRUE(),
'GL'[Document No.] IN {30017530,30017534,30017532}, "_delete",
BLANK()
)
May i know how to modify the above to ex-clude these 3 number ? I have try :-
_delete_py =
SWITCH(
TRUE(),
'GL'[Document No.] NOT IN {30017530,30017534,30017532}, "_delete",
BLANK()
)
admin11 , Try like
_delete_py =
SWITCH(
TRUE(),
NOT ('GL'[Document No.] IN {30017530,30017534,30017532}), "_delete",
BLANK()
)
1 Reply
- amitchandak
Super User
admin11 , Try like
_delete_py =
SWITCH(
TRUE(),
NOT ('GL'[Document No.] IN {30017530,30017534,30017532}), "_delete",
BLANK()
)