Alteryx Designer Desktop Discussions

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

Number Conversion

PB41091
8 - Asteroid

I have numeric values ad double data type --> 0.34472

I want to convert this value into % and round up to 1 decimal and make it display as 34.5%

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula

HI @PB41091 

 

try with this formula tostring((ToNumber([Field1])*100), 1)+"%"

 

Felipe_Ribeir0_0-1664884322099.png

 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

DavidSkaife
13 - Pulsar

Hi @PB41091 

 

Use this formula:

 

DavidSkaife_0-1664884223376.png

 

binuacs
20 - Arcturus

@PB41091 One way of doing this

binuacs_0-1664884384909.png

 

Felipe_Ribeir0
16 - Nebula

Hi @PB41091 

 

It worked?

 

 

PB41091
8 - Asteroid

It worked, thanks :)

Labels