If Contains Formula Error

[cwoo]

Hi 

I am having an issue with If Contains formula. Please see the screenshot attached.

[Portfolio] is V_String and I don't understand why the error message says that it tried to apply string operator to numeric value. 

Thank you for your help.

[dsmdavid · Accepted solution]

Hi Cwoo,

I think you need to split the formula:

IF contains([portfolio], "ONYX") AND contains([portfolio], "SYMPHONY") then "YES" else... etc.

[cwoo]

Thanks! That was an easy fix...