Jump to content

An "Average" question...


This topic is 7578 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7578 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.