I have converted nulls to default values with no luck. I have also tried a formula similar to what you have provided - changing only the fields that pertain to my report. To date, my nulls are still not showing up.
The problem is this: I am running a report to show all medical appointments that occur in a month - whether scheduled, in process or completed. If an individual does not have an appointment, we still want their name to appear on the list - and it does not appear if there is no appointment pending.
Do you have any additional advice?