Alteryx Designer Desktop Discussions

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

Round a number

bh1789
8 - Asteroid

if the below data is coming through as V-WString:

 

0.19741

 

How would I round it to a number of 20%?

 

 

Thank you

 

2 REPLIES 2
alexnajm
17 - Castor
17 - Castor

Round(ToNumber([Data])*100, 1)

 

if you want to show the percent sign, you’d have to force it back to string using ToString and adding the “%” at the end!

binuacs
20 - Arcturus

@bh1789 one way of doing this, note that  you cannot make it numeric format because % is string type, so when you add % the data should be in string data type

image.png

Labels