Display only the first three digits !!

[sarah77]

If i've a numeric fields with (1.753781) value so how can I display or treat with only the first three decimal digits to be (1.753) without any ROUNDATION ??.


Thanks for any help sent

 

[ramani]

HI
Use the following fomat. The key is to use the picture clause.

? VARiable1 PICT "99999999.999"

Hope this helps you ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[chpicker]

Well, it's rather complex, but try this:

nNum=1.753781
cNum=STR(nNum,10,10)
nFinalNum=VAL(LEFT(cNum,AT('.',cNum)+3))

 

[marsh]

Try ((int(###*1000))/1000) where ### is your number.

 

[sarah77]

Thanks for all of you ....
Ramani solution works only for display
Chpicker and Marsh solutions works for display and for any process suh as * / - +

Thanks for all of you

 

[chpicker]

I like Marsh's solution better, myself. It makes more sense and is a LOT less complex than mine. )

Ian