[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Calculating a running balance
- Subject: Calculating a running balance
- From: Adam Harborow <adam.harborow@ZURICH.COM>
- Date: Mon, 19 Feb 2001 14:21:37 +0000
Hello
I am using BRIO Report builder 6, Windows NT 4.0, Oracle 7.3.4.
I am trying to compile a report that takes the form similar to a bank
account statement. I have a starting balance and an end balance but I also
have numerous transactions (debit/credit column) that occur between the
start and end balance. What I need to do is have a running balance (under
the heading balance) of the different transactions eg:
debit/credit Balance
100 (starting balance)
-50 50
200 250
100 350
-150 200
200 (end balance)
Basically I have the debit/credit data and the start/end balance. I just
need to create a running total balance. I need a good starting point hence
the lack of any code.
Thanks in advance
Adam