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