I have the folloiwng data

 

Item #      qty sold         sales           average price

 

123              5                100.00

123              7                  75.00

 

 Totals        12               175.00           14.58

 

254               6                600.00

254               5                500.00

 

 Totals         11              1,100.00          100.00

 

I have used the sum to get the totals by item group and used the group totals for getting the average price (175/12 and 1100/11). Now i want to filter the records to show oply records where the Average Price is >= 95.00. When i use the group while selecting records i am getting a message that This formula can not be used because it must be evaluated later. Can someone help.

 

Hem Reddy

 

Thank you very much.

 

Hem Reddy