Need Formula Help to convert result into a percentage with one decimal place

Platform discussions
1

Help me correct this formula? Need result to be a percentage with at least one decimal place.

CONCATENATE((ROUND({Actual}/{Plan}*100),1),““,”%”)

2

Hi Adam,

Does this work? Should it show a decimal place even when it’s an exact percentage? This won’t do that, but it’s also possible.

CONCATENATE(
    ROUND(
        {Actual}/{Plan}*100,
        1
    ),
    " ",
    "%"
)
3

I will give it a try. I ended up using this formula with success:

text(divide({Actual},{Plan}),“0.0%”)