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

Sat, 14 Sep 2013 11:35:11 GMT

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

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)

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

Fri, 10 Jan 2014 09:53:36 GMT

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 — Fri, 10 Jan 2014 10:04:05 GMT

This should do the trick:

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

HTH

Jonathan