Help

Combining % formula field with Text field

Topic Labels: Base design Formulas
695 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Wendy_Yelsik
6 - Interface Innovator
6 - Interface Innovator

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

Wendy_Yelsik_0-1691086498594.png

Desired result - "3.69% | Increase"

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

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

1 Reply 1

Try

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