Hello,

I am just wondering how do I get the average of a formula?

For example in designer view:   

group 1   unit price
group 2   formula (price/qty)
group 3   (average of group 2)- don't know how to do it??

What it looks like on the report:

       Unit Price

          $7
          $10
          $7
        ______
          $8

Thanks!

Thanks for the tip, but it gives me an error saying {@price/qty}cannot be summarized. Any suggestions?

Hrm..... I tried few times, it kept giving me wrong number. I don't use detail section, so the unit price shows in my group 2 section. And this is my first time using a formula doing a manual running total, I am not sure where do I place all the formulas?

Many thanks!!