Formatting percentage numbers in a formula

[Michael_Benson]

Hi there,

Let’s say I have a formula field - Field A - that produces a decimal value (e.g., 0.5).

I use the formatting option within the formula field to display this value as a percentage.

However when I call that field in another formula - Field B - it is displaying using the original decimal value.

Is there a way to format my the ouput in Field B, so that it displays as a percentage value?

Currently Field B is outputting data like:

0.5
0.8333334
0.2

I want Field B to output:

50%
83%
20%

If anyone could help that would be much appreciated!

[ScottWorld]

What is your formula? All parts of your formula must result in a number (or be blank) in order to format it numerically.

[Michael_Benson]

Hi Scott,

Field B is going to output both text and numbers.

So, for example it currently shows:

{% Calc} & " Text"

This then outputs:

0.833334 Text

But I would like it to output:

83% Text

I had tried this formula to manually alter the format:

({% Calc} * 100) & "% Text"

But it still shows all the extra decimals and outputs:

83.3334% Text

Any help would be great :slightly_smiling_face:

[kuovonne · Accepted solution]

You need to round the number to get rid of the extra decimal places.

CONCATENATE(
    ROUND(
        {% Calc} * 100,
        0
    ),
    "% Text"
)

If you have more complex needs when converting a number to a text string, you can use my Ready Made Formulas app with a premium license.

[Michael_Benson]

kuovonne:

CONCATENATE(
    ROUND(
        {% Calc} * 100,
        0
    ),
    "% Text"
)

Thank you @kuovonne , this worked perfectly!