I am attempting to write a formula in analytics to discern whether the value of the "Constituent Display Name" is equal to the value of the "Recipient Constituent Display Name" for a set of orders (basically wanting to find out which tickets/orders have been shared to other patrons). I figured a CASE statement might be a good route to go for this, but I am having troubles finding a formula that works. Here's what I have written so far:
CASE WHEN [Constituent Display Name] = [Recipient Constituent Display Name] THEN 'Equal' ELSE 'Not equal' END
The message I am getting with this formula is "Function Syntax Error: End expected." I also tried swapping out "equal" and "not equal" for 1 and 0, and that gave me the error message "Error in "CASE" statement in 'condition_1': Expecting parameter type of 'Boolean' that consists of expression types 'Member Expression'. Instead found 'Dimension Expression'".
If anybody has any tips, that would be appreciated! Thanks!
In general, the first CASE statement is ended correctly. Is there possibly another CASE statement in the expression that is missing the END keyword? If all CASE statements in the expression are not properly ended, then this message would be displayed.
For the second error message, Ensure the data types of the columns in the statement are of the same type. If they are, there may be something else in the larger expression causing the error.