Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Decimal to Percentage

alexnajm
17 - Castor
17 - Castor

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

12 REPLIES 12
Sandra_R
5 - Atom

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
17 - Castor
17 - Castor

@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
5 - Atom

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. 

Labels