Expression not working with if condition using not in ?

ashmitp869 — Wed, 17 Aug 2022 01:47:12 GMT

Please help me with the below expression

=If(ED_VISIT_TYPE_CD -= {'12','13'} and ED_SEPARATION_MODE_CD -= {'99'},1,0)

Re: Expression not working with if condition using not in ?

sidhiq91 — Wed, 17 Aug 2022 02:58:09 GMT

@ashmitp869 You are using the Set analysis syntax in the If statement. You can write it as below as

if( not match (ED_VISIT_TYPE_CD,'12','13') and not match(ED_SEPARATION_MODE_CD ,'99'),'1','0') as New_Column

This should resolve your issue.