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

Question

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 the first column. i.e one total at the end of each day in a third column. This is the parent table.

QuickBaseJunkie · Answer

If you group your records by Day, you'll get a record count on the group header.

You could then also "show summary table based on the grouped columns" to get a summary at the top of your report that may be a little easier to read.

Here is an example of the report settings:

It isn't exactly what you described, but may provide you with the same info without too much effort.

Sign up

Login to the community