CASE WHEN {type} = 'Journal' THEN {memo} ELSE WHEN...
# general
s
CASE WHEN {type} = 'Journal' THEN {memo} ELSE WHEN {type} = 'Expense Report' THEN {memo} ELSE WHEN {vendor.entityid} IS NULL THEN {name} ELSE {vendor.entityid} END