Hi,

I want to extract a part of values from the decimal field. I want to covert the decimal value i.e. "0.00010000" to string and extract the value from left untill it is not whole number. for example, in the above value I want to get out "0.0001" from left and the rest of 0s on the right side on 1 should be omitted on the report. Similarly, if the value in the database field is "0.02000000" then I just want to extract the value "0.02" and rest of 0s should not be displayed on the report. I got the below code which works fine but it does returns NO VALUE if the value in the database field is "1.00000000". I want it to return "1" if the value is 1.00000000.

if tonumber(datafield) = 1.00000000 then '1'
else

local stringvar text:=totext(datafield), 8,"");
local numbervar n:=3;

while text[n] = '0' do

(n:=n+1);
text:= left(text,n);


Any Idea plz?

GJ

Hi,

I tried below code

Thanks Emir.... it worked perfectly