Freehand SQL - Coalesce
Hello - are there certain SQL commands Yellowfin does not like? I am trying to write a simple COALESCE statement in a report and can't seem to get the expected results. My statement is:
I expect the first NOT NULL field to be returned, but instead I'm getting no fields returned (even though there are values in at least one or more fields).
Do I need to format this query differently?