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
Thanks Dan, I'm getting there.
Also found this very simple example on YouTube - Accumulated Monthly Sales Example
http://www.quickbase.com/quickbase-blog/calculating-accumulated-sales-with-quickbase
I am trying to wrap the concept around our current architecture and modify field names in my brain to make more sense, then I will know if it's doable. If not I'm off to the JS books for a refresher.
I know it is possible because I can create a Summary report with a calculated running total.
Also found this very simple example on YouTube - Accumulated Monthly Sales Example
http://www.quickbase.com/quickbase-blog/calculating-accumulated-sales-with-quickbase
I am trying to wrap the concept around our current architecture and modify field names in my brain to make more sense, then I will know if it's doable. If not I'm off to the JS books for a refresher.
I know it is possible because I can create a Summary report with a calculated running total.