Weighted average.

[Bobi]

Hi. I want to give different weight to salarys from two different companies. And calculate the average. However my expression doesnt work. 

I compare my salary levels (MySalaryLevels) with the market, and in the expression below it works fine with avg(MarketSalaryLevels).

Avg([MySalaryLevels])/avg([MarketSalaryLevels]

However when I try to get the weight by:

(Avg([MySalaryLevels])/avg (TOTAL <IPE,Country> [MarketSalaryLevels]*Weight) )

Then I dont get the expected value. I want the MarketSalaryLevels to get summed up like:

If marketcompany A: salary 50 000, weight: 50 %. Company B: Salary 40 000, weight 50 %. Then that avg expression should give 45 000.) Country and IPE are 2 dimensions that allways will be selected. Job function is a third dimension which also will be selected. (This column is hided until these are selected)

Any suggestions on how to correct the formula according to my expectations?