Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formatting percentage numbers in a formula

Topic Labels: Formulas
Solved
Jump to Solution
5191 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Benson
6 - Interface Innovator
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
kuovonne
18 - Pluto
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.

See Solution in Thread

4 Replies 4

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

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
18 - Pluto
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.

Thank you @kuovonne , this worked perfectly!