Get avg($Field)

[#1]

Hello,

I am designing a table based on ColumnNames. The target is to display all columns which are like '*LeadTime' as rows.

So i am using the dimensions as

=if(wildmatch($Field,'*LeadTime'),SubField($Field,'_',2))     -Workshop

=if(wildmatch($Field,'*LeadTime'),SubField($Field,'_',1))     -Previous Falg

I want to calculate average

So when i tried =avg($Field), it is not giving results as required.

Please suggest, how I can acheive this.

Thanks,

Deepa

[Anonymous]

Can you attached your sample QVW

[arulsettu]

HI try this

=avg([$(=minstring($Field))])

[#4]

Please find attahced the sample QVW file for reference

[#5]

It always gives the average of min(filedname),

I am looking for average of filed name.

sorry..

[anbu1984]

=avg(Len($Field))

[#7]

Hi Anbu,

=avg(Len($Field))

it, considers average of the length of the field,

I am looking for average of field value

[renjithpl]

Hi Deepa,

Can you please show a sample output which you are expecting in an excel sheet.

Cheers

Ren

[Anonymous]

Hi Deepa

If you are looking for avg length of your fields then you can use =sum(len($Field))/count($Field)

[#10]

Hi

I am not looking for the length of field names

I am looking to get the average of field values.

I want to evaluate the avg(Received_Beginning_Leadtime) for 1st row

avg(Beginning_Surfaced_Leadtime) for second row

Thanks