Convert String into Double

[techbender]

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!! 🙂

[atcodedog05 · Accepted solution]

Hi @techbender 

You can use a formula like this.

Workflow:

Hope this helps : )

[techbender]

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!

[atcodedog05]

Hi @techbender 

In ToNumber() dot is treated as a decimal point.

Happy to help : )

Cheers and have a nice day!

[techbender]

Thank you, you too! Take care 🙂

[atcodedog05]

You too 🙂