Hi. I have a problem changing the field type from string value to numeric ($000.00) field but every time I change it from v_string to any other data type in the ‘SelectTool’ the field changes to ‘null’ (data file is text/csv). I’m trying to make it so that the sign amount and payment amount in my data set are numeric that way when I export the findings to Tableau it will be a measurable value. Any help is greatly appreciated. Thanks!
To change '$000.00' from string to numeric you must remove the '$' character. I've attached a module as an example.
Once you export to Tableau you can set the Default Number Format to Currency in the data window.
to_number.yxmd
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
