Problem with using the WHERE function

[Former Member]

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!

[Former Member · Accepted solution]

Hello Troy,

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.

Regards,

Harry