Aug 03, 2023 11:16 AM
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})
Aug 03, 2023 03:35 PM
Try
ROUND({01% DIFF OFFICE}*100, 3)&”% | “&{CHANGE TYPE}