In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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