Averaging fields in a table

[#1]

Hi,

I got a table as below, I want to average those values

Eg: avg(A), avg(B)

but if I got a N/A figure on the column I want to avg only the values

Eg: In column B I want to avg values 10, 8, 8

In column C I want to avg values 5, 0, 7

Can any one tell me how do I do it, Thanks in advance...

A	10	9	10	8
B	10	N/A	8	8
C	5	N/A	0	7

[anbu1984]

Are A,B,C field names or 3 different rows?

[#3]

Hi Mazaf,

Do you want a total?

or these values are in the field?

By default qlikview take the avg of the values which are present

I mean: for B (10+8+8)/3

with Reagrds

harshita Gaur

[anbu1984]

Load Avg(A),Avg(B),Avg(C) Inline [

A,B,C

10,10,5

9,N/A,N/A

10,8,0

8,8,7 ];

[#5]

see the attached file

[#6]

Hi Harshita,

I want avg not total but if the field had a values 'N/A' I want skip that field and avg other figures

in your example you haven't mentioned 'N/A' in the field

[#7]

did you check the attached qvw. qlikview by default generate the avg of field which has values

Regards

harshita Gaur

[#8]

Hi mufaz,

if you don't get the values then try this

=sum(A)/count( {<A-={''}>}A)

With Regards

Harshita Gaur

[#9]

see the attached file