Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting the amount field in string to double

phajiyev
5 - Atom

I have a field which shows the amount as String in following format "3,000,000.00 USD" and I want to convert it to double to show it as 3000000.00 without a currency and store it in a double format. Is there any formula I can use to make this conversion without using multiple Alteryx tools?  

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @phajiyev 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1643891137332.png

 

Hope this helps : )

 

binuacs
21 - Polaris

@phajiyev another method using Regex replace

binuacs_0-1643892299249.png

 

 

 

Labels
Top Solution Authors