Alteryx Designer Desktop Discussions

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

Converting a string into a number

mvangodung
5 - Atom

Hi guys - in Alteryx - how do you convert a string into a number?  Basically my data comes in as a string with a dollar sign from the souce and I want it converted to a number so I can aggregate it. 

 

Eg:

 

$1,234.50 should be 1234.50

 

Thanks

12 REPLIES 12
talexander
5 - Atom

This solution is great and I have used it many times... I'm running into an issue though when the "-" sign appears after the number. It is extremely annoying the data is like this but is there a way to either flip to "-" sign to the front of the number or retain the "-" to convert to number?

talexander
5 - Atom

Nevermind I belive I have figured it out using:

 

if right([data],1)= "-" then "-"+[data] else [data]

Diemm
8 - Asteroid

This function really works. I have the same problem few days ago but thanks to you i was able to fix it.

 

Great Job.

Labels