community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

How to show '%' sign after each number?

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 

Highlighted
Atom

Hi,

 

You could add a formula tool and use the following: 

 

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

 

Hope this helps!

 

Alex

Alteryx Partner

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.

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

Asteroid

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. 

Meteoroid

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 

Meteoroid

Hi @Amy18 ,

 

You can use the Suffix option in the Vertical Axis section of the Configuration window. I have attached the solution. Does this help?

 

Regards,

Sujan

Asteroid

Sorry. 

No, I would like to see % added to each number label.

Like on your example, can I see 1.2%, 21.3% and 33.3 on the chart? 

 

Thanks. 

Meteoroid

Hi Amy,

 

Yes you will. I have slightly altered the chart property to make sure it does. Please refer to the properties for the axis and the series (1 in this case). I have attached the output which i printed as a pdf for you.

 

Regards,

Sujan

Asteroid

Thanks.

 

That helps. 

Labels