4 Replies Latest reply on Aug 20, 2018 10:13 AM by meenu choudhary

    Converting a String Into a Percentage

    Larry Newdorf

      I am working with a database field that uses a String value for a percentage field:  ex:  "98%"

       

      Tableau is reading this in as a String (which the column data type in the db table).  I wanted to convert this value to a number/percentage so I can sort the column where it is being displayed.

       

      The value does display as a string but cannot be sorted.  Setting it to a number causes an empty (null) value.

       

      Thanks for taking a look.

       

      Larry