13 Replies Latest reply on Mar 8, 2013 4:46 AM by andy swartz

    How do I remove a "$" from a string using a calculated feild

    andy swartz

      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