Avg of avg ...

[#1]

Hi and sorry for my poor english,

In this picture you will find the different field I have in a table

Col1 is an ID

Col2 is an ID

Col3 is a list of ID referenced in Col2 (the green, black and red lines)

Assuming we have a col5 with value I want to average with all data present in Col3.

Today I'm able to get this average data making first and avg on 180, avg on 182 and avg on 181 then I make an global avg of the 3 values (using subfield)

Unfortunatly, I loose precision make avg of avg.

What I want is make avg value of line (69+70+71+72+73+74+75)/7 and not  (avg(69) + avg(70+71+72) + avg(73+74+75) / 3)

Is there a way to do this with this kind of table structure ?

I hope I'm clear ...

Thanks in advance.

[sunny_talwar]

Not sure I completely understand, would you be able to share a sample qvw file and provide the expected output in terms of numbers