I have a line items database. It has a whole lot of info that I can use to sort and summarize.

Here is the problem I am running into...

I have a report that gives me the total, in $, that I have sold for the day.

Each Line item is sorted by date and it is then summarized as it should be giving me the total for each day.

The problem I am running into is that it seems to be giving me an average per line item in the sub-summary instead of an average by day.

so on days that I make $1200, $800 and $900 I end up with an average of $11.7556666.

What do I have to do to get it to give me an average by Date and not by Line Item?

Check that the break field in the subsummary part is specified as date, and not line item; also, the sort field must be the first one in the sort order list as well. I suspect from what you say above that your first sort is on line item, and not date. Put the date at the top of the sort list, and see if that fixes the problem.

How are you generating the average?

1) Using the Summary field "Average" setting?

2) Using a calculated field based upon summary fields (Total/Count)?

-bd

It is Sorted by "Day Name" and then by "Date"

Then the sub summaries are...

1. "Date" "Totals" "off Average by" (off average is a calculation that I am using until I figure this out.)

2. Day name with the Summary field of total $$ made on those days.{this is where I want the "Average per day" to appear.

They appear on the report in reverse order aka. #2 is printed above #1

This works fine as long as I do not call up multiple day names. If I do, it averages the same on all days rather that per day.