There are 2 problems:
A) the fact that this is an error, I don’t think it should be an error
B) the error message is wrong it talks about parens when all the parens are correct
My test case (note the single quotes next to a and b in the string):
SWITCH([_THIS],
“Oustanding”, “”,
“Completed”, “”,
“Waived”, “a’” & “'b”,
“Not Applicable”, “”,
“Already Have”, “”,
“”
)
meets this error:
Expression ‘SWITCH([_THIS], “Oustanding”, “”, “Completed”, “”, “Waived”, "a’" & “'b”, “Not Applicable”, “”, “Already Have”, “”, “” )’ could not be parsed due to exception: Number of opened and closed parentheses does not match.
I tried these variations:
-
no single quotes → PASS
SWITCH([_THIS],
“Oustanding”, “”,
“Completed”, “”,
“Waived”, “a” & “b”,
“Not Applicable”, “”,
“Already Have”, “”,
“”
)
-
single quotes in string but no concatenation → PASS
SWITCH([_THIS],
“Oustanding”, “”,
“Completed”, “”,
“Waived”, “a’'b”,
“Not Applicable”, “”,
“Already Have”, “”,
“”
)
-
using CONCATENATE instead of & yeilds the same error → FAIL
LinkedIn
Twitter
