Convert Number to Decimal data

[JenzEkan]

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.

[ShankerV]

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 · Accepted solution]

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:

[Felipe_Ribeir0]

Hi @JenzEkan 

One way of doing this

[ShankerV]

Hi @JenzEkan 

Please find the expected output.

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