Select SUM(TUTAR) Toplam_Tutar
from (
SELECT ITM.CODE,ITM.PRODUCERCODE,ITM.NAME,TOT.ONHAND MIKTAR,(CASE WHEN TOT.INVENNO='0' THEN 'ÜRETİM'
WHEN TOT.INVENNO='1' THEN 'HMF'
WHEN TOT.INVENNO='3' THEN 'TEMSA'
WHEN TOT.INVENNO='-1' THEN 'TÜM AMBARLAR' END)AS AMBAR,
(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT
FROM LG_300_01_STLINE
WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND
LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) FİYATI,
TOT.ONHAND*(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT FROM LG_300_01_STLINE
WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND
LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) TUTAR
FROM LV_300_01_GNTOTST TOT INNER JOIN LG_300_ITEMS ITM ON ITM.LOGICALREF=TOT.STOCKREF WHERE TOT.INVENNO='1' ) Hepsi