Jump to content

Calculate balance for all record


This topic is 7506 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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). wink.gif

Link to comment
Share on other sites

This topic is 7506 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.