Problem with using the WHERE function
It doesn't seem like I can use a list within a WHERE Function.
My lastest try was simply this:
=<Where Test> where <PSS Type> inlist ("Site Visit", "Telephone")
This gives me a syntax error. I have tried all kinds of different bracketing but to of no avail.
It will work with Singular Values:
where <PSS Type> = "Site Visit"
But not with an OR thrown in there
where <PSS Type> = "Site Visit" OR <PSS Type> = "Telephone"
For my purpose I 100% need two values. Can it not evaluate more than one constant in the statment?
Please advise. Thanks!
Harry van der Kolk replied
The where-clause only works with equal-to.
What you could do is create a workaround by creating a variable where you check if the values like:
=IF <variable> = value_1 OR <variable> = value_2 THEN "SHOW" ELSE "NOT SHOW"
You can then use the variable for your where-clause.