Help!! How to calculate Average? (Six-Sigma, PPK)

[#1]

Hello,

I am trying to build a Xmr Chart with the data below. I always calculate the Average and the Moving Range Average with the selected data only

ID_1	VALUE	LSL	USL	MovingRange
1667331	16,6	8	20	-
1137512	12,931	8	20	3,669
1667326	11,1	8	20	1,831
1667325	11,1	8	20	0
1667324	16	8	20	4,9
1137513	11,0837	8	20	4,9163
1667323	18,5	8	20	7,4163
1137514	13,5468	8	20	4,9532
1137515	12,931	8	20	0,6158
1137516	13,5468	8	20	0,6158
1137517	14,1626	8	20	0,6158
1137518	16,0099	8	20	1,8473
1137519	9,8522	8	20	6,1577

My dimension is: =If((Filter=vF_0)And(vAllowCalc=1),ID_1),

expression is: =If((Filter=vF_0)And(vAllowCalc=1),VALUE1),

expression for MovingRange is: =If(((Filter=vF_0)And(vAllowCalc=1)),fabs(Above(VALUE1)-VALUE1)).

I cannot make expression for calculating average of the MovingRange expression

=If(((Filter=vF_0)And(vAllowCalc=1)),fabs(Above(VALUE1)-VALUE1)).

All my attempts were unsuccessful

Can anyone help me please?

Thank you very much.

(see attached file)

[#2]

Hi Ivan,

I'm also finding same kind of solution with small change like with aggr.

Do you got the solution if yes, please share to me.

Thanks in advance.

Regards,

venkat

[jonathandienst]

Hi

This should do the trick:

=Avg(Aggr(If(((Filter=vF_0)And(vAllowCalc=1)),fabs(Above(VALUE1)-VALUE1)), ID_1))

HTH

Jonathan