If Contrains Expression help

[pvara]

Need some help with the expression if the value 3 is contained in [Ref] then I would like "Y"

Not sure if the commas are causing an issue.

[patrick_digan · Accepted solution]

@pvara try switching the positions of Ref and Ref1 in your formula. It's very confusing.

[ArnavS]

Hi pvara,

Instead of using the Contains() Formula, I would try with the In() Formula. 

For example: IF [Ref1] IN ([Ref]) THEN "Y" ELSE "N" ENDIF

Lets give this a try and see what happens. 

Arnav

Alteryx

[bpatel]

hi @pvara ,

in your formula your variables are in the wrong place. Ref should be first then Ref1

if Contains([ref], [ref1]) then "y" else "n" endif

Hope this helps!