Running Total In Script

[#1]

Hai,

I'm trying to get the running in total in script.Please refer my atatchment.Also i 've tried with the following script:

IF(ACCOUNT=PEEK(ACCOUNT), ([AMOUNT] + PEEK(RAMOUNT)),[AMOUNT]) AS RAMOUNT

Please do the needul..

Thanks in Advance..

[cotiso_hanganu]

It works, reading from your file.

Beware: field names are case sensitive !

Sempre fi,
Cotiso

load *,
IF ([Account Code]=peek([Account Code]), (Amount + peek(RAMOUNT)),Amount) AS RAMOUNT;

LOAD [Account Code], Yearmm, Amount, [What I want]
FROM .\Data.xls (biff, embedded labels, table is Sheet1$);