11 Replies Latest reply: May 16, 2018 12:30 PM by Shivesh Singh RSS

    how to get decimal value of a field

    TRISHITA BANERJEE

       

      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?