How to coalesce fields in a report
I have an existing Saved Report where I need to do the equivalent of the COALESCE() function that is available in Saved Searches. I don't find a way to get at the SQL functions within the report builder, so don't seem to be able to do call COALESCE() directly. How can I accomplish this behavior in a Saved Report?
In particular, I have two different name fields (let's say Name1 and Name2), neither which is populated for all the records in the search. I need a new column (call is Name3) that consists of the contents of Name1 IF it is not empty; otherwise it needs to display the contents of Name2.