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
MarkShnier__You
Qrew Legend
Qrew LegendI suggest trying a Summary Report Type,
Summarize Total Dollars (normal)
Summarize Total Dollars (running totals)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Summarize Total Dollars (normal)
Summarize Total Dollars (running totals)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------- MarkShnier__YouIf you use the method which I suggested to make a summary report and use that an an embedded report of the children in the parent Record form, then you will get exactly what you asked for as a result.
You need to create a report of type Summary, not a summary field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Hey Mark! Can you clarify what you mean by "embedded report of the children in the parent Record form"?
I've been struggling with the formula for a running total.
------------------------------
Kelsey Poole
------------------------------
