CASE WHEN Help
I need some assistance with a CASE WHEN statement.
I have an offer report where I would like to add in the Comments added to the candidate submission by specific users. The offers may not always have comments to add but when they do I want them to pull in this report. I attempted to add a filter to accomplish this but unfortunately, these filters caused the report to only showed offers where there were comments added.
I attempted a CASE WHEN statement but I keep getting an error. Below is the statement:
CASE WHEN "Submission Tracking History"."Transaction Event Name" IN (‘Comments Added’) THEN "Submission Tracking History"."Transaction Comments"