Dear friends,

I have problem in postgresql  view.  This is the view (Pay attention to the red and blue colours):

SELECT tblpenjualan.tanggal, tblpenjualan."operator", tblpenjualan.noinvoice, tblpenjualan.bayar, tblpenjualan.bayarvocher, tblpenjualan.jam, tblpenjualan.id, tblpenjualan.jeniscard, tbltransaksi.kodeproduk, tbltransaksi.keluar, tbltransaksi.harga, tbltransaksi.disc1, tblproduk.namabarang, tblproduk.subkat, tblsubkategori.subkategori, tblkategoriproduk.kode, tblkategoriproduk.kategori, tbltransaksi.hargapokok * tbltransaksi.keluar AS modal, tbltransaksi.keluar * tbltransaksi.harga - tbltransaksi.disc1 / 100::numeric * (tbltransaksi.keluar * tbltransaksi.harga) AS jumlah, tbltransaksi.keluar * tbltransaksi.harga - tbltransaksi.disc1 / 100::numeric * (tbltransaksi.keluar * tbltransaksi.harga) - tbltransaksi.hargapokok * tbltransaksi.keluar AS profit
   FROM tblpenjualan
   JOIN tbltransaksi ON tblpenjualan.id = tbltransaksi.jualid
   LEFT JOIN tblproduk ON tbltransaksi.kodeproduk::text = tblproduk.kode::text
   LEFT JOIN tblsubkategori ON tblproduk.subkat::text = tblsubkategori.id::text
   LEFT JOIN tblkategoriproduk ON tblsubkategori.kategoriid::text = tblkategoriproduk.kode::text;

The result is :

"2008-07-20";"ULY";"01-200708";"Tunai";0.00;"1899-12-30 21:14:47+06:55:25";1;"";"8993417200021";1.00;4200.00;0.00;"ELIPS HAIR VITAMIN ";"121";"VITAMIN RAMBUT";"NF";"Non Food";3960.0000;4200.000000000000000000000000;240.000000000000000000000000
"2008-07-20";"ULY";"01-200708";"Tunai";0.00;"1899-12-30 21:14:47+06:55:25";1;"";"8991001111425";3.00;1650.00;0.00;"TAKE-IT MILK CHOCOLATE WAFER 17 G";"8";"BISKUIT";"MKN";"Makanan";4680.0000;4950.000000000000000000000000;270.000000000000000000000000
"2008-07-20";"ULY";"01-200708";"Tunai";0.00;"1899-12-30 21:14:47+06:55:25";1;"";"8991115000103";2.00;1600.00;0.00;"ALPENLIEBE ORIGINAL 41 G ISI 10 BTR";"62";"PERMEN";"MKN";"Makanan";3000.0000;3200.000000000000000000000000;200.000000000000000000000000
"2008-07-20";"ULY";"01-200708";"Tunai";0.00;"1899-12-30 21:14:47+06:55:25";1;"";"8990800010533";1.00;1600.00;0.00;"MENTOS CHEWY DRAGEES 37 G";"62";"PERMEN";"MKN";"Makanan";1500.0000;1600.000000000000000000000000;100.000000000000000000000000

Why  the calculation result has so many decimals ?

Thank you