Creating checkbox in rich text field via scripting

[Wendy_Yelsik]

What formula would I use to combine these two fields and get this result?

Desired result - "3.69% | Increase"

I tried this formula and the result is in % STATUS off…

CONCATENATE({01% DIFF OFFICE}&' |'&{CHANGE TYPE})

[pressGO_design]

Try

ROUND({01% DIFF OFFICE}*100, 3)&”% | “&{CHANGE TYPE}