Forum Discussion

Qrew Member

7 years ago

Sum product in one column by day/date in another column

I have a column with dates and time in one column and in the adjacent column there are corresponding production numbers. What I would like to do is sum the corresponding production numbers BY DAY in t...

reports and charts

_anomDiebolt_

Qrew Elite

7 years ago

You appear to be asking for a cumulative sum. This can be done using the OEH Technique using this formula:

"<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

QuickBaseCoachD

Qrew Captain

7 years ago

If you do a regular Summary report you can choose to have a column show as a running total down the page.

Forum Discussion

Sum product in one column by day/date in another column

Related Content

Adding number of Business Days to Date

Calculating number of days between two date fields

Add 1 day to date formula

Moving Fields from One Table to Another

Copy Single Table from One App to Another