How do I replace text with unicode

suwandy

Hello,

 

I'm trying to replace some characters in my table using Unicode Characters such as :white_heavy_check_mark: and with :cross_mark: 

This is the code I typed into the Beast Mode but it's not displaying it and instead only showed the literal '✅', could anyone please help?

 

Case when `Last Week Actual` - `Last Week Target` >= -9999 then 
'✅'
when `Last Week Actual` - `Last Week Target` >= 0.001 then 
'❌'
else '' End

Thanks in advance.

Ashleigh

Hiu @suwandy  you have to include the <div> tag like this, I also attached a photo of what it showed. 

 

 

CONCAT('<div style="">', -- Combine data and format

'&#9989;',

' Hello ', COUNT(`IMPL_DT`),

'</div>' -- end format

)