Hello All,
Firstly, I apologies for bad english.
I have such problem. There is my table in which I intensively enter the data. the structure of the table is that.
As you see, I have 4 fields: komp1, komp2, komp3 and komp4 (these mean component 1, component 2, component 3, component 4). I want to calculate such indexes for each № (01 and 02):
Index 1=(average of komp1) * (0,1)
Index 2=(average of komp2) * (0,4)
Index 3=(average of komp3) * (0,2)
Index 4=(average of komp4) * (0,3)
I made this query:
The result is such:
The indexes are only average values of komp1, komp2, komp3, komp4 . but they aren't propagated on the coefficients 0,1; 0,4; 0,2 and 0,3.
please help me.
thank you beforehand!