Registered User Joined: 2/24/2005 Posts: 58
|
Hello All, I am having a challenge figuring out how to write an "effecient" way to show a condition for 5 consecutive green Bars between C2 and C10.
I realize i could write a lot of "or"s and make it lengthy, but i was hoping someone could show me a way to streamline the PCF.
thanks.
Will
|
Registered User Joined: 2/24/2005 Posts: 58
|
this is what i came up with so far, but, I'm thinking there is a more effecient way to write the PCF:
(C1 > C2 and C2 > C3 and C3 > C4 and C4 > C5 and C5 > C6 ) or
(C2 > C3 and C3 > C4 and C4 > C5 and C5 > C6 and C6 > C7 ) or
(C3 > C4 and C4 > C5 and C5 > C6 and C6 > C7 and C7 > C8) or
(C4 > C5 and C5 > C6 and C6 > C7 and C7 > C8 and C8 > C9) or
(C5 > C6 and C6 > C7 and C7 > C8 and C8 > C9 and C9 > C10) or
(C6 > C7 and C7 > C8 and C8 > C9 and C9 > C10 and C10 > C11)
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I cannot think of an obvious way to make it more efficient as a Condition Formula.
You could just use:
C1 > C2 and C2 > C3 and C3 > C4 and C4 > C5 and C5 > C6
And use it in a Custom PCF % True Indicator however. If you set the Period to 6 and the Average Type to Simple, you could click on it and select Create Scan Condition to check for the Custom PCF % True Indicator to be Greater Than 0.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|