Weighted average

[#1]

Hi All, I have the following problem: my information drills down in country-region-Channel. I have the variable "Physical Distribution" per country-region-channel but i want to see that variable in just for "Country". It must be an average, but a weighted average (weighted by Volume). How can I code that?

example.

Chile -> Santiago --> Traditional : physical distribution = 90 , Vol = 200.000

Chile -> Santiago --> H & S : physical distribution = 56 , Vol = 100.000

Chile -> Santiago --> Modern : physical distribution = 80 , Vol = 20.000

Physical Distribution for Santiago : ( 200.000/320.000 * 90 + 100.000/320.000 * 56 + 20.000/320.000 * 80)

[#2]

Hi,

Please, look into an attached example.

I hope it will help you.

Kind regards,

JTPro

[Oleg_Troyansky]

Try this:

sum(PD * Volume) / sum(Volume)

cheers,

[#4]

Thank Janusz, your example was very helpful. I adapted it and everything seems to be working right.

[#5]

I'm trying to accomplish something similar, but with a weighted time average and I just can't manage to get it to work. I got data with the structure like the attachment and I want the weighted average waiting time per skill. I've tried using both a <TOTAL> and an AGGR, anybody got any ideas?

[#6]

Figured out the problem was in my set analysis and not in my formula, <TOTAL> worked fine.