Start Free Trial

Alteryx Designer Desktop Discussions

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

change a percentage column to 2 decimals

Disey
7 - Meteor

Hi

 

I have a column of percentages currently as a V_WString (see below) and wish to change it to 2 decimal points if anyone can help please?

 

%
0.633536389868548
0.485031143258991
0.403537563822028
0.616086708499715
0.162882054230143

 

I want it to show

63.35

48.50

etc

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

Round(ToNumber([%])*100,0.01)

Disey
7 - Meteor

perfect, thank you :)

alexnajm
18 - Pollux
18 - Pollux

Fantastic - please accept my response as a solution then. Thank you in advance!

Labels
Top Solution Authors