Accumulative columns

[#1]

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

[swuehl · Accepted solution]

You could probably make use of a chart inter record function, try e.g.

= opening_balance + rangesum(above(daily_total,0,rowno()))

Regards,

Stefan