4 Replies Latest reply: Jan 11, 2016 3:13 AM by Ahmad Kastero RSS

    Convert from Varchar to Number

    Ahmad Kastero

      Dears,

      Good day and i hope you are in good health.

       

      how can i convert the varchar to number like if i have this data in the data source table (5.1 ,5.2 ,......., 5.9 , 5.10 , 5.11) the same dara is appear in my QV but the issue is with all value that have  (5.10 ,5.20 , 5.30 )  i try to convert it to number but still the seam issue.

       

      any ideas about this.

       

      this is a sample of my data. i try to convert it to number but still the same issue

       

      Message was edited by: Ahmad Kastero