In my SQL talble I have a column of numbers/currency that includes the "$". How can I use a calculated feild to remove the "$" so Tableau can recognize this data point as a number/currency, rather than a string. If I simply change the 'Data Type' in Tableau, leaving things as is, the values just go to Null
Thank you
A
13 answers
Andy,
If your field is named [Transportation Charge], then create a calculated field with the following code:
FLOAT( MID( [Transportation Charge], 2) )
Right click that calculated field in the data window and select "Field Properties" --> "Number Format" and select Currency (or Currency Custom).
Hope that helps!
