AnsweredAssumed Answered

Sub-summary in a date range

Question asked by ichiban on Aug 10, 2017
Latest reply on Aug 16, 2017 by ichiban

I am working with truck peddles and specifying a date range.  I am trying to specify total dates for each peddle during this date range (i.e. if Iowa has 10 stops for July 1st, that would count as 1 date).  Each peddle will have several different stops of various weights.  I am trying to get an average of weight based on total peddle dates.  My table has an entry with all information for each stop for each peddle.

 

For instance;

 

Peddle Date Range - July 1st, 2017 - July 31st, 2017

 

Peddle                 Total Peddles for Month            Total Weight       Avg. Weight

 

Iowa                                        20                                  100,000               5,000

Minnesota                               10                                   45,000                4,500

Nebraska                                 15                                   60,000                4,000

 

I am struggling with coming up with the total peddles during that month as well as the Avg. Weight.  Any help would be appreciated.

Outcomes