how to calculate running total based on two column values

[asini]

Hello All,

can you please give me a help hand regarding to the below problem

presently i have a report with structure as below in report studio (8.3)

TransactionDate,Detail,City,Amount,OldBal
Nov 1, 2008,paybill for x-x-11-2003,win,-1200.73,710.00
Nov 3, 2008,Call Card,win,33.45,710.00
Nov 3, 2008,Insured Amount,ATL,55.22,710.00
Nov 5, 2008,intercom transfer,win,47.98,710.00
Nov 7, 2008,BOA disbursement,NYC,723,710.00
Nov 7, 2008,Incoming BOA Chicago,CHG,-105.56,710.00
Nov 7, 2008,seychellis air forth,DC,675,710.00
.......
........
.........
Nov 30, 2008,Kennedy air tranfer,NYC,-9805.56,710.00



oldbal is always same because it is single amount,
now how can i add running total of amount, with initial value as oldbal

for ex: in above example 710 is old bal, so 710+ (-1200.73) so the values in oldbal like below

TransactionDate,Detail,City,Amount,OldBal
Nov 1, 2008,paybill for x-x-11-2003,win,-1200.73,710.00
Nov 3, 2008,Call Card,win,33.45,-490.00
Nov 3, 2008,Insured Amount,ATL,55.22,-435.51
Nov 5, 2008,intercom transfer,win,47.98,-387.53
Nov 7, 2008,BOA disbursement,NYC,723,335.47
Nov 7, 2008,Incoming BOA Chicago,CHG,-105.56,229.91
Nov 7, 2008,seychellis air forth,DC,675,904.91


how can i achieve this above oldbal please

hardly tried with different running-total,moving-total but some where else i am doing something wrong

please help me

Grateful to all of you

Best Regards
asini

 

[asini]

Please Help me

any idea please.....

 

[asini]

Hello All,

kindly any ideas please

basically the problem is need to calculate running total for a column (initiat start is stored in another dataitem)

this initial data item contains only one value

 

[asini]

thanks for all whom ever tried at least to help me
Dear All,

it may helpful to some others

running-total([Amount]) + [OldBal] - [Amount]

works fine
this idea given by Jurri (Master)

Regards
asin