Skip to main content

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})

Try

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


Reply