Chart Table Calculation

[#1]

Im having difficulty with a calculation or 2 in a table chart.

the green items i can get no problem, those are my fields that i have available. the orange fields i cant get right, i must get the total of a column but for a specific TestNumber only...

So for AvgTest i want the total of AvgSample divided by 10(Sample) BUT ONLY FOR THE SPECIFIC TESTNUMBER.

Same with DiameterAvg. I want the total of Diameter divided by 10 (Sample) but only for the specific testnumber.

The sheet below is what it should look like if the calculations work. Any help? Im exhaust trying to figure out how to use a criteria of TOTAL TestNumber only..

[lironbaram]

hei

attach is an example of what you asked for

it uses the total in the avg fields

hope its helps you

[jonathandienst · Accepted solution]

Ruan

Perhaps this:

Avg(TOTAL <TestNumber> Sample)/10

Jonathan

[amars]

Hi Ruan,

Couldn't understand ur problem. But search for RangeAvg() , ur solution lies in that.

[#5]

Here is another explanation.

TestNumber, Sample, One, Two & Diameter is data from our quality control SQL.

They do a TEST which consist of 10 samples each. for each sample 2 different values is taken in.

So this i done in excel quickly, COLUMN E must display the average of reading ONE & TWO which is easy. My problem is with COLUMN F & H.

It must SUM all the values from COLUMN E for each seperate test number then divide it by die Sample amount (10 on most days, but i use max to not hardcode it).

So in effect i will have 10 of the same values linked to a different sample number.

[#6]

just tried this now, this is EXACTLY what i wanted.

so the <TestNumber> part specifies that the TOTAL must only be applicable to within TestNumber field correct?

[jonathandienst]

Ruan

so the <TestNumber> part specifies that the TOTAL must only be applicable to within TestNumber field correct?

Correct

Jonathan

Please approve the post so that others can see the preferred solution.

Yet another Qlikview Blog