Decimal to Percentage

[alexnajm]

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

[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 · Accepted solution]

@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))+"%"

[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.