Forum Discussion
Weighted Average
- Anonymous9 years ago
The solution was very easy.. it just needed a littele mathmatics -_-'
A =(1/(1+212+23+45+23+12+32+11+22)*.8)+(212/(1+212+23+45+23+12+32+11+22)*.5) +...etc
==>the rule says
(x/y*w) + (z/y*o) = ((x*w)+(z*o))/y... "y" will be changed dynamicly during any filter... also "x" ,"z", "w" and "o"
==>so our first equ is equevelant to
((1*0.8)+(212*.5)..etc)/(1+212+23+45+23+12+32+11+22)
1-((1*0.8)..(212*.5)..etc) ===> this is a calculated column1 =[D]*[E]
2-((1*0.8)+(212*.5)..etc) ===> this is a measure:=sum([calculated column1])
3-(1+212+23+45+23+12+32+11+22) ===> this is measure2:= sum([D])
4-((1*0.8)+(212*.5)..etc)/(1+212+23+45+23+12+32+11+22) ===> this is measure3:= [measure]/[measure2]
this is it..
The solution was very easy.. it just needed a littele mathmatics -_-'
A =(1/(1+212+23+45+23+12+32+11+22)*.8)+(212/(1+212+23+45+23+12+32+11+22)*.5) +...etc
==>the rule says
(x/y*w) + (z/y*o) = ((x*w)+(z*o))/y... "y" will be changed dynamicly during any filter... also "x" ,"z", "w" and "o"
==>so our first equ is equevelant to
((1*0.8)+(212*.5)..etc)/(1+212+23+45+23+12+32+11+22)
1-((1*0.8)..(212*.5)..etc) ===> this is a calculated column1 =[D]*[E]
2-((1*0.8)+(212*.5)..etc) ===> this is a measure:=sum([calculated column1])
3-(1+212+23+45+23+12+32+11+22) ===> this is measure2:= sum([D])
4-((1*0.8)+(212*.5)..etc)/(1+212+23+45+23+12+32+11+22) ===> this is measure3:= [measure]/[measure2]
this is it..