How to show '%' sign after each number?

gurpreet-singh

Hi, I am performing a percentage calculation between two columns.

My business requirements is that each number should also have a '%' sign besides it. for example: (1.2%, 21.34%...)

current percent column:

1.2

21.34

33.33

Desired outcome:

1.2%

21.34%

33.33%

Can someone please guide me to how I can get from current percent column: to Desired outcome: ?

Thank you,

Gurpreet

Topic of Interest

Help

Accepted answers

abrouwer

Hi,

You could add a formula tool and use the following:

ToString([Current Percent Column], 2) + "%"

Hope this helps!

Alex

Add Percent.yxmd

tcroberts

Are you using a Table Tool for reporting at any time in your workflow? If so, in the column settings, you can add a Suffix to your column. Specifying % in the text box would also accomplish this while allowing your data to behave as a number.

All comments

abrouwer

Hi,

You could add a formula tool and use the following:

ToString([Current Percent Column], 2) + "%"

Hope this helps!

Alex

Add Percent.yxmd

tcroberts

gurpreet-singh

Thank you, both the solutions are very helpful, really appreciate your time and help

Amy18

Hi,

If I would like to see Percentage in my Chart using Charting Tool, how can I do it?

I cannot change the number to string format. if so, I will not be able to generate the chart.

Thanks.

Jashthebest

Hi Gurpreet,

you can also try the function PadRight(ToString([Number]), Length(ToString([Number]))+1, "%") and it should take care of any number of decimals

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703