I’m trying to compare two fileds in a calculated field using contains function, but the function throws error for substring as “argument doesnt not have correct type”. Is there an alternate to contains or am I missing something here?
The same fucntion works when I replace the substring with literal value - “ABC”
Locate isn’t efficient for my use-case although it sounds like an alternate, I was not able to test it.
Instead I got around creating a parameter in QS and used the contains option in the custom filter.