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
------------------------------
- MarkShnier__You
Qrew Legend
If 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
------------------------------- MarkShnier__You@Kelsey Poole
This was a bit of a long thread so it's not super clear to me what your use case is. Why don't you go ahead and post a new question and I'll watch for it and respond there.
it will also be easier freely me to picture your used case if you use the real names of the tables involved for your parent and child records.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
