Registered User Joined: 5/1/2009 Posts: 10
|
Good morning,
Want pcf formula for swing low and swing high. Tried L>L1<L2<L3 but it brought me results for the last several days. I would like just the most recent, if possible.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Assuming the formula represents the desired logic, it just needs to be re-written to represent proper syntax. You can only make one comparison at a time in a Condition Formula, so it needs to be:
L > L1 AND L1 < L2 AND L2 < L3
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|