Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 tables, 1 for daily transactions and 1 for opening balances. I require a field that accumulates the opening balance to the daily totals. In this way i will get the daily balance of the account.
eg if the opening balance is 1000
eff_date | daily total | accumulative total | |
---|---|---|---|
1/09/2011 | 100 | 1100 | |
2/09/2011 | 300 | 1400 | |
3/09/2011 | 200 | 1600 | |
You could probably make use of a chart inter record function, try e.g.
= opening_balance + rangesum(above(daily_total,0,rowno()))
Regards,
Stefan
You could probably make use of a chart inter record function, try e.g.
= opening_balance + rangesum(above(daily_total,0,rowno()))
Regards,
Stefan