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
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