Sub-Summaries Calculations

[Tony Leslie]

I'm having trouble making calculations within a sub-summary panel. Example: a sub-summary panel lists total sales volume per salesman and the quantity of units sold, using two summary fields. I want the average sale price per salesman, so I create a calculation field that divides the summary field for dollar volume by the summary field for units sold. This works fine when I place it in the grand summary panel, but in the sub-summary panel it shows the grand total result. Same thing happens for any other type of calculation. Any suggestions would be greatly appreciated.

[comment]

As a rule, you need to use the GetSummary() function when referring to summary fields in calculations involving sub-summaries.

In this case, you have an easier option: define a summary field as average of Price, weighted by Quantity.