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

Hi @techbender 

You can use a formula like this.

Workflow:

Hope this helps : )

million.yxmd