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

LiamLiam

Qrew Member

7 years ago

This 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.

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