I have customer table that has a column for the customer_name.
It can be blank. If it's blank, I can get the name from 2 columns as well, called firstname and lastname.
How can I combine these two to display with blank?
So that my formula would look like:
If Customer_Name > ' ' then Customer_Name else
Firstname + ' ' Lastname