Convert String into Double
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey everyone!
I'm a newbie to Alteryx but loving it so far!
Currently working on trying to convert some funding data types from String data into Double. Seems easy enough but the funding string data has the numbers abbreviated (attached below).
Ideally, I would like to set up a formula or maybe utilize a tool that will output the first row as '63,300,000', the second row as '1,700,000,000', and so forth. If anyone has some helpful documentation that'll lead me in the right direction, I'd appreciate it!
Thank you!! 🙂
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
oh wow!! lol I was definitely overthinking it. Just to clarify, does the ToNumber function remove the '.' ?
Thanks a bunch @atcodedog05! Sweet profile pic too!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @techbender
In ToNumber() dot is treated as a decimal point.
Happy to help : )
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, you too! Take care 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You too 🙂