Averaging a Sum Field

[Niet32]

I have a report setup with Sum Parts. I have a field "Market" that sums up a number of records for a number of markets per brand. I can't just add up the numbers for every market because they are not related. So I am trying to get an average for all markets but I am not figuring it out.

Any Ideas?

Thanx!

[Niet32]

Let me clarify:

I have 40,000 records.

There are 25 markets.

Each market sells a different product.

I want to know what the average sales for all the markets are.

How do I do this? It sounds easy but I'm not seeing it!

[QuinTech]

Hi, Niet, and welcome to FM Forums!

It sounds like you may want to make a separate table now for Markets. A good rule of thumb is, if you think about something as a distinct entity, you probably want a table for it.

Now, in your Markets table, you can make a field called TotalSales, which could be a summary field of all related records in the Products table. Now make another summary field called AverageSales which is the average of TotalSales. This should do the trick.

Jerry