I also tried CASE WHEN {type} = 'Journal' THEN {memo} WHEN {type} = 'Expense Report' THEN {memo} WHEN {vendor.entityid} IS NULL THEN {name} ELSE {vendor.entityid} END