9 Replies Latest reply on Feb 28, 2017 10:54 AM by Raymond Xie

    Tableau converting varchar to decimal failed

    Raymond Xie

      I have a dataset with data as below:

       

      1ThyroidFemales96.00 %
      2ThyroidBoth sexes93.00 %
      3Kaposi sarcomaMales90.00 %
      4Melanomas of the skinMales85.00 %
      5Other urinary systemFemales85.00 %
      6Melanomas of the skinBoth sexes80.00 %

       

       

      The last column is NOT a decimal, I tried to convert it to decimal but Tableau returns all as null.

      Screenshot - 28_02_2017 , 10_38_58 AM.png

       

      Other than doing the converting in the data source side, how can I do the converting in Tableau?

       

      Thank you very much.