Add a Running Total as a field in a table.
We have a Parent-child relationship. One of the fields in each child record has an amount. We want to include a running total of the amount in each subsequent record where the total has only the previ...
Forum Discussion
If you have never deleted any records, you can related the table to itself and have a field called [Link to previous record ID] with a formula of Record ID# - 1]. Then lookup the previous running total and add the current value to it, so like a daisy chain.
On a going forward basis you can set the role permissions to ensure that no records get deleted, only made inactive by a check box field to filer off reports.
Then no doubt you have deleted some records, so the daisy chain will be broken several times along the way. You will need to have a [Parent Record ID# override] field so you can skip the missing links.
So the formula needs to be
IF([Parent Record ID# override]>0, [Parent Record ID# override], [Record ID#] -1)
On a going forward basis you can set the role permissions to ensure that no records get deleted, only made inactive by a check box field to filer off reports.
Then no doubt you have deleted some records, so the daisy chain will be broken several times along the way. You will need to have a [Parent Record ID# override] field so you can skip the missing links.
So the formula needs to be
IF([Parent Record ID# override]>0, [Parent Record ID# override], [Record ID#] -1)