I feel like I've written this a dozen different ways and yet this formula keeps returning 'Empty' when custbody5 is definitely not empty.
CASE
WHEN TRIM(NVL({custbody5}, '')) != ''
THEN '<div style="background-color:yellow; color:black; font-weight:bold;">'
|| {custbody5} ||
'</div>'
ELSE 'Empty'
END
Can anyone tell me how I'm supposed to write this case to return custbody5 but highlighted when not null?
Highlighted is custbody5, Empty is the formula result.