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
Solved! Go to Solution.
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?
Nevermind I belive I have figured it out using:
if right([data],1)= "-" then "-"+[data] else [data]
This function really works. I have the same problem few days ago but thanks to you i was able to fix it.
Great Job.