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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.