Forum Discussion
_anomDiebolt_
6 years agoQrew Elite
You appear to be asking for a cumulative sum. This can be done using the OEH Technique using this formula:
Cumulative Sum
https://haversineconsulting.quickbase.com/db/bnxqbmgw4?a=q&qid=1
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=674
"<img src onerror='window.QBU_Sum=window.QBU_Sum+" & [Quantity] & "||(window.QBU_Sum=" & [Quantity] & ");this.outerHTML=QBU_Sum'>"
Cumulative Sum
https://haversineconsulting.quickbase.com/db/bnxqbmgw4?a=q&qid=1
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=674
- LiamLiam6 years agoQrew MemberThis is close to what I'm after but i need to go one step further. Using the attached picture, I'd like to sum the numbers in the left column according to the days in the right column.
- QuickBaseCoachD6 years agoQrew CaptainIf you do a regular Summary report you can choose to have a column show as a running total down the page.