I am trying to create the following Saved Search F...
# general
c
I am trying to create the following Saved Search Formula (Text) for a Purchase Order based search: CASE WHEN {status} = "Rejected by Supervisor" THEN "Yes" ELSE "No" END I keep getting the ERROR: Invalid Expression outcome for this field. I've tried variations of = or IS, and double and single quotes but nothing is working. Any ideas?
t
I was able to get it to return a result with single quotes: CASE WHEN {status} = 'Rejected by Supervisor' THEN 'Yes' ELSE 'No' END
c
Thank you! I had double quotes around Yes and No, which was the problem 😞
👍 1
n
Use single quote