Alteryx Designer Desktop Discussions

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

Convert Number to Decimal data

JenzEkan
8 - Asteroid

Hey Guys, 

I have a requirement in which I need to convert the spends from 19873452 to 198.73 and so on. Please help me how can I achieve this.

4 REPLIES 4
ShankerV
17 - Castor

hi @JenzEkan 

 

You can use the left function to trim first 3 numbers and then add . and then joining the remaining numbers.

 

Do you have any logic to be implemented in specific. 

grazitti_sapna
17 - Castor

Hi @JenzEkan , Another way of doing it using round function. This will be useful if your data has exact same number of digits you have specified. Let me know if it helps:

 

grazitti_sapna_0-1674822198318.png

 

Sapna Gupta
Felipe_Ribeir0
16 - Nebula

Hi @JenzEkan 

 

One way of doing this

 

Felipe_Ribeir0_0-1674822197865.png

 

ShankerV
17 - Castor

Hi @JenzEkan 

 

Please find the expected output.

 

tonumber(Left(tostring([Field1]),3)+"."+right(Left(tostring([Field1]),5),2))

 

ShankerV_0-1674822339258.png

 

 

Labels
Top Solution Authors