Hi, Just posting here so anybody can use it. 12345/1000 = 12.34 not
12.35 Code: 12.34 Floor(ToDouble(@CONTENT4)/1000)+'.'+Substring(
Iif(Length(ToString(Mod(ToDouble(@CONTENT4),
1000)))<=1,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'00'
),Iif(Length(ToString(Mod(ToDouble(@CONTENT4),
1000)))=2,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'0'
),ToString(Mod(ToDouble(@CONTENT4), 1000)))),1,2 ) Code: 12.35
Round(ToDouble(12345)/1000,2) Regards,Anil