Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

requesting PCF help of Avg( Avg(AvgC4,42)-Avg(AvgC28,42), 21 ) Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mjtran
Posted : Monday, June 1, 2015 9:17:11 AM
Gold Customer 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

Bruce_L
Posted : Monday, June 1, 2015 10:18:06 AM


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
mjtran
Posted : Monday, June 1, 2015 10:32:14 AM
Gold Customer 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
Bruce_L
Posted : Monday, June 1, 2015 11:01:23 AM


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
mjtran
Posted : Monday, June 1, 2015 11:15:57 AM
Gold Customer Gold Customer

Joined: 2/1/2006
Posts: 98

Thank you for the correction.  It works very nicely!

Bruce_L
Posted : Monday, June 1, 2015 11:19:55 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.