How do you calculate the cumulative total of children rows only
How do you calculate the cumulative total of children rows only in a column? I have a column of contract contingency amount, another column showing draws from this contingency and I want to create a third column with a cumulative total of how much is left of this total contingency amount after each withdrawal. But I only want to calculate this cumulative remaining total using the child rows as I have multiple parent/child relationships with each parent representing a different total contingency amount as the start point for the withdrawals.
Help Article Resources
Check out the Formula Handbook template!