Calculate balance for all record

[Henry]

Hi there, now i have created a simple cashbook for testing. It only have 5 field, date, description, debit, credit and balance. The balance is based on previous balance plus debit - credit. I can do this with a script. Now just asking is that any way to do this by using calculation field. So it can calculate automatically without running a script.

Regards,

Henry

[CobaltSky]

Hi Henry,

There are varioius ways to approach this, but perhaps the simplest would be to create a calculation field called cRecordBalance with the formula Credit - Debit, then redefine your balance field as a summary field to return the Total of cRecordBalance (and select the checkbox option for 'Running Total' at the bottom of the summary field options dialog).