Skip to Content
0
Former Member
Dec 02, 2009 at 08:00 PM

Average values in rows

43 Views

Hi, gurus!

I have a problem. I have following data:

Val_type_Batch___Summ___Quantity__Price

1_______1_______100$____10______10$

1_______1_______200$____10______20$

So, I need to calculate Average Price in Val_type, so for Val_type 1, it is 15$, and I need to get following query:

Val_type_Batch___Summ___Quantity__Price_____Av_Pr

1_______1_______100$____10______10$______15$

1_______1_______100$____20______10$______15$

Is it possible?

Edited by: Mikhail Sychev on Dec 2, 2009 9:01 PM

Edited by: Mikhail Sychev on Dec 2, 2009 9:04 PM