tengo la siguiente consulta y no se como realizar el calculo de otra columna que me lleve el saldo acumulativo
SELECT
A.DOCNUMBR,EXTDCOST,DOCDATE,A.ITEMNMBR,TRXQTY,UNITCOST,TRXLOCTN,TRNSTLOC,A.DEX_ROW_ID,DOCTYPE,
(
CASE WHEN TRXQTY>0 THEN TRXQTY*QTYBSUOM ELSE 0 END) AS ENTRADA,
(
CASE WHEN TRXQTY>0 THEN (TRXQTY*QTYBSUOM)*UNITCOST ELSE 0 END) AS COSTO_ENTRADA,
(
CASE WHEN TRXQTY<0 OR DOCTYPE='3' THEN ABS(TRXQTY)*QTYBSUOM ELSE 0 END)AS SALIDA,
(
CASE WHEN TRXQTY<0 OR DOCTYPE='3'THEN (ABS(TRXQTY)*QTYBSUOM)*UNITCOST ELSE 0 END)AS COSTO_SALIDA
FROM
IV30300 A
WHERE
A.ITEMNMBR <'01-01-007'
AND
A.DOCDATE BETWEEN '2008-12-01' AND '2008-12-15'
AND
TRXLOCTN BETWEEN '01' AND '11'