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
It's a good question that I do not know how to answer. I will guess that the parent table defines the order of the child table on a reference proxy named "Work Order #". Any records in the child table associated with the parent "Work Order #" are grouped together using this field.
I am imagining a numeric formula field that uses the above relationship detail to locate the previous RID. If I can get the previous RID then I can do the running total.
I am imagining a numeric formula field that uses the above relationship detail to locate the previous RID. If I can get the previous RID then I can do the running total.