Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
It working fine. problem? post your sample data .
-Hirish
Maybe try
Num(Num#(Field, '#'),'#.000') as field
Is it the different number of decimals that cause a problem for you?
Hi,
SET DecimalSep='.';
in your defined Variables.
Is it Same do check.
-Hirish