Running Totals
I have a child table with data in different years. I have a field called Total Dollars that totals the cash by year. I'd like to have a Running total of the cash each year. How do I do that? -----...
Forum Discussion
I have the first one Summarize Total Dollars (normal) but don't know how to do the second one Summarize Total Dollars (running totals)
------------------------------
Mike McCartney
------------------------------
------------------------------
Mike McCartney
------------------------------
I might not have asked the question right. I have a field called Total Dollars by Year (Formula Numeric) which calculates all the data in each season. Can I create another Formula Numeric field that serves as a running total by Adding the previous year to all the data in that season? This way, in my grid on the Parent Table, I can show Total Dollars by Year and Total Dollars earned through life of contract to that point.
For example:
Year Total Dollars Total Dollars Earned
1 $100 $100
2 $150 $250
3 $125 $375
------------------------------
Mike McCartney
------------------------------
For example:
Year Total Dollars Total Dollars Earned
1 $100 $100
2 $150 $250
3 $125 $375
------------------------------
Mike McCartney
------------------------------