I have a report that should give me the average # of days to ship orders for each of our customers. I use the aggregate function for COUNT_OF_SHIPDATE in the detail section that resets in the footer. When I use the count feature in the table, it gives me the proper number of ship days and therefore the proper averages. In the report however, it gives me the total # of orders regardless of the ship date being null. Do you have any suggestions?
Jim
