how to get decimal value of a field

[trishita]

Load


FUEL_MASS_AFTER_SOUNDING,
FUEL_MASS_BEFORE_SOUNDING,
(FUEL_MASS_AFTER_SOUNDING-FUEL_MASS_BEFORE_SOUNDING) AS DEVIATION_AFTER_SOUNDING,
FUEL_TYPE,
IMO_NUMBER AS IMO_NO,

FROM
[mo_purch_sounding_correction_view.qvd]
(qvd);

The DEVIATION_AFTER_SOUNDING field shows value as -42000 but I want to see it in decimal -42.608 format.

How to convert this field into decimal?

[trishita]

currently I am doing it in this way:

Num( SoundingCorrections.DEVIATION_AFTER_SOUNDING/ 1000, ' ###.##', ',', '.' )

Its working now

[shiveshsingh]

Glad to know it worked