Cast decimal point for the division of 2 decimal fields

[skhuon]

Hi, when I divide Sum (AMT_NET_GAAP_GNLS)/Sum (AMT_UPB_FM) and these two fields are decimal fields, the results is 0

I know there is a way to cast the decimal point but i keep on getting errors,
How do I cast decimal (14,13) for the result of
Sum (AMT_NET_GAAP_GNLS)/Sum (AMT_UPB_FM) ?



select
Sum (AMT_NET_GAAP_GNLS)/Sum (AMT_UPB_FM)
from udbadm.mol_cl_closd_hst
Where dt_sts_closd between '08/01/2006' and '08/31/2006' and date (dt_srce_end) = '01-01-9999'
and flag_del <>'Y'and cd_mrtg_ls_type = 'REO'
GROUP BY CD_FM_RGN, ind_unit

[ronverdonk]

I don't see why the decimals are cut off, but what about using the FORMAT()? As in

SELECT FORMAT(0.0004 / 0.0123, 10)

Ronald :cool: