Hi, I'm trying to create an expression in a ...

expressions
(Terry Jacob) #1

Hi,

I’m trying to create an expression in a slice but it doesn’t seem to let me use an apostrophe. This is my expression:

AND([DATE] = <TODAY(), [PROMOTION]=Gus’s Market)

I get this error message:

Expression ‘AND([DATE] = <TODAY(), [PROMOTION]=Gus’s Market)’ could not be parsed due to exception: Number of opened and closed parentheses does not match.

Is it not possible to use an apostrophe in an expression?

(Philip Garrett) #2

@Terry_Jacob

Try quoting the string value

AND([DATE] = <TODAY(), [PROMOTION]=“Gus’s Market”)

(Terry Jacob) #3

@Philip_Garrett_Appsh That worked. Thanks for your help.