Calculating a running total

Discussions for the HanDBase for iPad and it's conduits and desktop add-ons

Calculating a running total

Postby Mcmar » Sat Oct 31, 2015 8:31 pm

How would I create a calculation where I would use just one field and have a running total for all records for that field?
Mcmar
 
Posts: 3
Joined: Sun Sep 27, 2015 11:14 am

Re: Calculating a running total

Postby Brian_Houghton » Tue Nov 03, 2015 6:36 am

Hi,

You can add the current value to the previous value of itself. Use the current and previous field selection tools in the upper left of the formula dialog.

The end formula will look something like P7+F7, which 7 being the number of the field you are using.
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 2246
Joined: Wed May 20, 2009 8:30 am

Re: Calculating a running total

Postby cenzer » Thu Dec 17, 2015 11:53 pm

The running total only updates by going to another record and returning or by changing some other field and then changing back.

Sent from my SGH-M919 using Tapatalk
Thank you.

Charles
cenzer
 
Posts: 109
Joined: Tue Jul 21, 2009 12:54 am

Re: Calculating a running total

Postby Brian_Houghton » Sat Dec 19, 2015 8:39 am

Hi Charles,

Thanks for posting.

This formula should update whenever you:

1. Open a record or create a new record
2. Modify one of the values used in the formula
3. Close the record

It won't auto update until the record closes because it reads data from all of the other records within the database.
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 2246
Joined: Wed May 20, 2009 8:30 am

Re: Calculating a running total

Postby cenzer » Sat Dec 19, 2015 10:34 pm

Thank you for the clarification.

Sent from my SGH-M919 using Tapatalk
Thank you.

Charles
cenzer
 
Posts: 109
Joined: Tue Jul 21, 2009 12:54 am


Return to HanDBase for iPad

Who is online

Users browsing this forum: No registered users and 1 guest

cron