>I can get the average of the individual sales that way but what I want is a >weighted average by dividing the total sales by the total boardfeet. for >example if there are three sales: 800 boardfeet for $132.00, 1372 bf for >$240.00, and 352 bf for $120.00 I can get an average of $226.94. What I >need is the total sales of $492.00 (which is printed in the group summary >band)* 1000 / the total boardfeet of 2524 (also printed in the group >summary band) for an average of $194.93/1000 bf. The report calculates the For weighed totals you need two report variables - one to keep the total amount, and another to keep the total quantity, reset both on the group level. In the group footer you should print total_amnt/total_qty, and that's the weighed average.