Sum of calculated field

[#1]

Dear all,

I hope someone of you can help me again

I have to following problem in a table diagram:
     - I want to sum all calculated fields

Example:

Product 1     Offer 1     Balance1          Avg. Balance?

Product 2     Offer 1     Balance 2         Avg. Balance?

The Balance is a calculated field = Old Price - Offer Price
Offer Price is a Input that I can call

Old Price is again a calculated field out of different fields.

I want to sum all the Balances and divide the sum by the number of products in the same offer. In short I need the avg. balance of all products

I hope it is clear what I want to do.... THANKS FOR YOUR HELP !!!

Cheers Martin

[MK_QSL]

Instead of Selling Price, use your formula there.. otherwise supply us the dummy database according to your need.