Pivot Table 'Summarize Values By' Average Not Recognizing Blank Cells in Average

Occasional Visitor

I have a pivot table containing weekly volume data, going back four weeks.  Problem is, when any one of the companies I'm tracking doesn't produce volume, there is no record in the source data.  So on the Pivot table for the last four weeks I might see blank blank blank 400.  I need the average in  this case to be 100, not 400.  Anyone know how to solve this?  Thanks in advance. Summarize Values By Average Summarize Values By Average

1 Reply
30 or 31 / 7 = INT(4.428571428571429) =4
so formula:
AMT / INT((30 or 31)/7)