Decimal to Percentage

Hello everyone!

I was hoping y'all could help me out with a small problem. The data set I have has numbers as decimals (i.e. 0.75). I would like it to be presented as a percentage (i.e. 75%) when I use the Render tool to produce a report. I feel like there is a simple solution but I am very new to Alteryx so I thought I would try to use the community! Thank you for any and all help.

Best Regards,

Alex Abi-Najm

Tips and Tricks

Accepted answers

jamielaird

Hey @alexnajm,

You'll need to use a Formula tool to create a string value. This will work:

ToString([Percentage]*100)+'%'

To include decimal places in your formatted percentage just use the Round function after multiplying by 100:

ToString(Round(([Percentage]*100),0.1))+"%"

Cheers

tom_montpool

@jamielaird's solution certainly works, however, I want to point out that the ToString function has the built-in ability to return a specified number of decimal places.

See the help link here -- ToString() Conversion

alexnajm

Hi @jjimenez,

No difference between them - they are interchangeable. The only benefit to using one versus the other is that if you wanted to put out the single vs. double quotes as part of the value (i.e. displaying 'Alex' in a Formula), then you can do " 'Alex' ". Also works the other way!

This works well for words like doesn't - it would need to be "doesn't" to work properly.

-Alex

alexnajm

@Sandra_R I’m confused by your question as you said the answer - the multi field formula. It’s just updating the field to accommodate multiple fields: ToString(Round(([_CurrentField_]*100),1))+"%"

All comments

jamielaird

Hey @alexnajm,

You'll need to use a Formula tool to create a string value. This will work:

ToString([Percentage]*100)+'%'

To include decimal places in your formatted percentage just use the Round function after multiplying by 100:

ToString(Round(([Percentage]*100),0.1))+"%"

Cheers

alexnajm

Thank you @jamielaird! That worked fantastically.

Best Regards,

Alex Abi-Najm

Corinne_W

Full steps to avoid errors when applying formula:

jamielaird

1. Use multi-field formula

2. Choose fields to be converted to %

3. Update the Change output type to String (since we are first multiplying your number by 100, then converting this number to a string

Use the formula:

ToString([_CurrentField_]*100)+'%'

Number of Percent.PNG

Corinne_W

Update for Tableau users: If you are outputting Alteryx data to Tableau, keep the data in decimals. Tableau can output the data as percentages. This saves a lot of time and unnecessary conversions.

NeilFisk

Although this is marked as "solved", I attempted to do this and, while using the reporting functions in Alteryx to generate charts, this method will result in graphic challenges, since string fields may not display correctly (i.e., lowest numerical value to highest) in a chart when it is now a string.

jjimenez

Hello Jamie,

Great solution!

I was hoping you can answer something for me. I've noticed in formulas sometimes they use single quotes and other times double quotes.

In your response you have 2 solutions. One with single and the other double.

How do I know when to use single quotes vs double quotes?

Thanks in advance for your clarification.

Jose

alexnajm

Hi @jjimenez,

This works well for words like doesn't - it would need to be "doesn't" to work properly.

-Alex

Sandra_R

In addition to the question above, I was able to use the Multi-Field Formula with the expression below. Is there a way to convert multiple numeric fields to output a string percentage or do they need to be converted individually?

ToString(Round(([%FTE to National]*100),1))+"%"

I have tried to add additional expressions within the same tool in various ways however I either get a Parse Error or no conversion at all

Thank you in advance

Sandra

alexnajm

CPacheco89

Just a note to other beginners like me: the formula can only be applied to numeric values, so even if your data is showing up as a decimal, it needs to be changed to a Fixed Decimal type in the select tool. Once I did that, everything else worked like a dream. Thank you, everyone, for your input; this community is definitely invaluable.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703