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
Solved! Go to Solution.
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
@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))+"%"