# Formatting percentage numbers in a formula

Topic Labels: Formulas
Solved
3488 4
cancel
Showing results for
Did you mean:
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
18 - Pluto

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.

4 Replies 4
18 - Pluto

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

6 - Interface Innovator

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:

18 - Pluto

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.

6 - Interface Innovator

Thank you @kuovonne , this worked perfectly!