Hi,
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?
distinct_countif({id},contains({Col-1},{col-2})) ,
The same fucntion works when I replace the substring with literal value - “ABC”
Hi @arunvg,
We hope the reply from @Max worked for you.
Let us know if this is resolved. And if it is, please help the community by marking the reply as a “Solution.”
Many Thanks,
Andrew
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.