Calculation including Summary Fields

[bdam]

I'm having a mental lapse and can't figure out how to do something that I swear I've done before.

The recordset is a bunch of books: how many pages they are and how much it cost to edit them.

For each record we want the per page cost. That's simple: cost / pages.

When sorted by division we want totals for cost and pages as well as the average cost per page. If I do the average of the individual per_page_cost fields the number isn't correct. If I create a calculation field with total cost / total pages (where they are summary total fields) I get the same result for each division.

What am I missing? I've attached a simple file that shows what I'm talking about.

Summary_Test.zip

[comment]

Try a summary field defined as Average of CostPerPage, weighted by Pages.

[bdam]

YES! That's the ticket. Thanks for catching that.