Gold Customer
Joined: 2/1/2006 Posts: 98
|
Hello Worden trainers,
Please help me with the following equation that I am trying to accomplish:
AVG( (Avg(AvgC2,3)-AvgC19), 5 )
I got Avg( AvgC2, 3 ) - AvgC19 the same as
(C0+2*(C1+C2)+C3)/6 - AvgC19
Then I translate it further with the next Avg( ***, 5 ), of the equation above, and got the following, but when I try to plot it out, it does not seem to be correct.
( (AvgC5.0+AvgC5.3)*0.83+(AvgC5.1+AvgC5.2)*0.6-Avg(AvgC19.0,5))
Your help is very much appreciated.
Thank you,
-mjtran
|
Gold Customer
Joined: 2/1/2006 Posts: 98
|
I think it came out to:
((C0+C7+3*(C1+C6)+5*(C2+C5)+6*(C3+C4))/30-Avg(AvgC19.0,5))
I wish it something much simpler than the equation above.
Please correct me if I am wrong!
Thank you,
-mjtran
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Your Indicator Formula should work, but the following might be a bit more intuitive.
(AVG(AVGC5,3) + AVG(AVGC5.1,3)) / 2 - AVG(AVGC19,5)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|