Average on Group Footer with variable

rbuser

It must be getting late or my brain is just failing me but I'm having
trouble trying to create an average on the group footer with a variable. I
can produce a sum but I'm having trouble creating an average based on a set
criteria. Here's what I'm getting:

Day Deliveries

Mon
Tue 1
Wed
Thu 2
Fri
Sat 5
Sun 4

Sum = 12
Average on days where deliveries occur = 3 (4 days - 12 deliveries)

My problem is that my average is using all 7 days instead of the 4 and gives
me an average of 1.71 instead of 3. I've tried a number of different
variables with no luck.

Any ideas?

nardmoseley

This message has been answered in the general newsgroup, please do not cross
post messages.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com