Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to calculate running total based on two column values

Status
Not open for further replies.

asini

Technical User
Nov 13, 2008
22
US
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
 
Please Help me

any idea please.....
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top