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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More

Convert number to percentage

Meteor

Hey!

 

I was hoping to convert a column in my workflow to %.

 

Screenshot below - (column - "Difference" - this is the difference between the Merival and ZEUS columns)

 

Thanks :)

 

Percentage.PNG

Alteryx Certified Partner
Alteryx Certified Partner

Hi @emiafshar

 

It depends of what kind of percentage you're talking about.

 

I assume you're calculating your percentage as = (Zeus - Merival)/Zeus * 100

 

So you can create a Field - Named as Percentage Difference, with the calculation above, and the use the following function:

ToString([Percentage Difference], 2) + '%'

 

The "2" rounds the number to 2 Decimal Places.

 

Cheers, 

Labels