Scenario: If the Record’s Billing City is not NULL it will return the Billing City > If the Billing City is NULL and Billing Country is NOT NULL it will return the Billing Country > If the Billing Country is NULL and Billing Phone is NOT NULL it will return Billing Phone> If the Billing Country up to the Billing Phone are NULL it will return NULL.
Using COALESCE function to return the first non-null expression in the list. Using If COALESCE function if all expression in the list are NULL the function will return NULL.
Solution: 1. COALESCE ({billcity},{billcountry},{billphone})
Note: The Case When equivalent of the COALESCE example above is > case when {billcity} IS NOT NULL then {billcity} when {billcountry}