Our next venture, is calculating a running balance.
In a running balance, we have a series of deposits and a series of withdrawals and we want to
keep track of the total of our balance at all times.
First, we need two columns. One has our deposits, the other has the withdrawals.
This is laughably easy really -- since BusinessObjects has a function Excel doesn't have: RunningSum
=runningsum([Deposit]) - runningsum([Withdrawal])
The result is :
In Excel this would be something like :
Looks like our balance is in the red -- but with the economic times, that seems right :)