12 Replies Latest reply on Mar 6, 2013 5:45 AM by andy swartz

    My source data include "-" for all negative numbers.  How can I get Tableau to correctly view this data as a number instead of a string

    andy swartz

      I need some guidance….  It looks like the last remaining
      data hurdle I am experiencing is SQL values that are negative.  These data
      points include a “ - “ sign in my origin files, and subsequently in the SQL
      files I am using as a Data Source.

        

      Tableau brings these negative values in as a String…as a result, they look like this;

         Capture.JPG

      When I convert the “Data Type” to “Number/Currency”, the values with “-“ go to Null;

       

            Capture.JPG

      I need a ‘fix’ that allows Tableau to recognize and aggregate this data correctly