Average value propagate on the number

[besoqor]

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!

[ConneXionLost]

Put this in place of the "Field":

komp1Avg: [komp1]*0,1

Cheers,