Gold Customer
Joined: 2/1/2006 Posts: 98
|
Hello Worden's trainers,
Please help me with the PCF for
Avg( Avg(AvgC4,42)-Avg(AvgC28,42), 21 )
Thank you much in advance,
-mjtran
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Indicator Formula.
(6 * (AVG(AVGC42,21) + AVG(AVGC42.1,21) + AVG(AVGC42.2,21) + AVG(AVGC42.3,21)) - AVG(AVGC42.4,21) - AVG(AVGC42.5,21) - AVG(AVGC42.6,21) - AVG(AVGC42.7,21) - AVG(AVGC42.8,21) - AVG(AVGC42.9,21) - AVG(AVGC42.10,21) - AVG(AVGC42.11,21) - AVG(AVGC42.12,21) - AVG(AVGC42.13,21) - AVG(AVGC42.14,21) - AVG(AVGC42.15,21) - AVG(AVGC42.16,21) - AVG(AVGC42.17,21) - AVG(AVGC42.18,21) - AVG(AVGC42.19,21) - AVG(AVGC42.20,21) - AVG(AVGC42.21,21) - AVG(AVGC42.22,21) - AVG(AVGC42.23,21) - AVG(AVGC42.24,21) - AVG(AVGC42.25,21) - AVG(AVGC42.26,21) - AVG(AVGC42.27,21)) / 28
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 2/1/2006 Posts: 98
|
Hello Bruce,
I was trying to make a boolean of
(Avg(AvgC4,42)-Avg(AvgC28,42)) > Avg( Avg(AvgC4,42)-Avg(AvgC28,42), 21 )
and applying what you just provided, the result always came back as FALSE.
(Avg(AvgC4,42)-Avg(AvgC28,42))>
((6 * (AVG(AVGC42,21) + AVG(AVGC42.1,21) + AVG(AVGC42.2,21) + AVG(AVGC42.3,21)) - AVG(AVGC42.4,21) - AVG(AVGC42.5,21) - AVG(AVGC42.6,21) - AVG(AVGC42.7,21) - AVG(AVGC42.8,21) - AVG(AVGC42.9,21) - AVG(AVGC42.10,21) - AVG(AVGC42.11,21) - AVG(AVGC42.12,21) - AVG(AVGC42.13,21) - AVG(AVGC42.14,21) - AVG(AVGC42.15,21) - AVG(AVGC42.16,21) - AVG(AVGC42.17,21) - AVG(AVGC42.18,21) - AVG(AVGC42.19,21) - AVG(AVGC42.20,21) - AVG(AVGC42.21,21) - AVG(AVGC42.22,21) - AVG(AVGC42.23,21) - AVG(AVGC42.24,21) - AVG(AVGC42.25,21) - AVG(AVGC42.26,21) + AVG(AVGC42.27,21)) / 28)
Sorry for all the trouble.
-mjtran
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The last + near the very end of the formula should have been a - instead. Please try it again.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 2/1/2006 Posts: 98
|
Thank you for the correction. It works very nicely!
|