SOLVED
Convert Number to Decimal data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JenzEkan
8 - Asteroid
‎01-27-2023
04:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
4 REPLIES 4
ShankerV
17 - Castor
‎01-27-2023
04:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎01-27-2023
04:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Sapna Gupta
Felipe_Ribeir0
16 - Nebula
‎01-27-2023
04:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ShankerV
17 - Castor
‎01-27-2023
04:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JenzEkan
Please find the expected output.
tonumber(Left(tostring([Field1]),3)+"."+right(Left(tostring([Field1]),5),2))
