Mean Help

[ajaykumar1]

Hi All,

I have the data week wise and the same has been arranged in horizontal way as per the attachment.

The expression which I have written is Sum(Quan1)/Sum(Quan2).

Now I want to calculate the mean.

1. e.g

Type      Week     37     38      39          Total          Mean                  Profile37                             Profile38

A                            5    10      15          30        10(i.e. 30/3)         0.5 (i.e. abs(5-10)/10         0 (i.e. abs(10-10)/10)

B

C

D

For Type B,C,D also same logics i have to apply.

Please help the same.

Thanks ,

Ajay

[anbu1984]

Mean = Total / Count(Week)

[ajaykumar1]

Thanks...But not working and even getting error when am tried total keyword also dont know why.

Any help from others also.

Thanks,

Ajay

[anbu1984]

I meant Total expression you shown above. If you still have issues, post your sample qvw

[ajaykumar1]

Hi,

Please find the sample data as well as the required output.

Let me know if in case of anything required.

Thanks,

Ajay

[ajaykumar1]

Any hint from anyone.

Thanks,

Ajay

[ajaykumar1]

Any help...

Many thanks,

Ajay

[anbu1984]

Can you provide qvw which you tried