When doing a comparison with NULL, I've noticed you have to say IS instead of =. So, try: {custcol_mdc_job} IS NULL THEN "-None-" ELSE {custcol_mdc_job.custentity_mdc_job_office} END