Skip to Content
0
Former Member
Dec 27, 2010 at 02:05 PM

Avg of accounts(parent member)

30 Views

HI friends,

I have product dim(in row), time(in col), qty/rate/amout(act dim member ids in col).

Product jan2010(qty) jan2010(rate) jan2010(amount).......dec 2010(amount)

p1 30 5 150

p2 10 5 50 ..

p3 20 5 100 ..

written script logic for each month wise, getting amount for p2 and p3.

P2 amount = P2 qty * p2 rate

P3 amount = p3 qty * p3 rate

Here p1 is parent of p2 & p3.

P1 qty should be summation of p2 qty & p3 qty.

P1 rate should be avg of p2 rate & p3 rate.

P1 amount should be summation p2 amount & p3 amount.

By default P1 qty, p1 rate & p1 amount are aggregated up. But i want p1 rate as avg of p2 rate & p3 rate.

Can it possilble by scipt logic or i have to simple excel for p1 rate calculation?

Thanks,