Expression not working with if condition using not in ?

[ashmitp869]

Please help me with the below expression

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

[sidhiq91]

@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.