Registered User Joined: 9/20/2016 Posts: 11
|
Hi there
Looking to create a PCF to scan for the baseline as it crosses up the cloud. The issue I have with the presets in v.18 is that it is an either/or option of crossing up Span A or Span B. I'm hoping to scan for crossing up the cloud as a whole. I'm not well versed in coding the PCF. Here's my attempt but it's not quite right. I was copying and pasting from other discussion trends.
(MAXH26.1 + MINL26.1) / 2 => (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C > (MAXH52.26 + MINL52.26) / 2 AND (C1 <= (MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 OR C1 <= (MAXH52.27 + MINL52.27) / 2)
Thanks
James
|
Registered User Joined: 9/20/2016 Posts: 11
|
I believe I found what I was looking for.
http://forums.worden.com/default.aspx?g=posts&t=60487
Testing it out now. Thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
XUP((MAXH26 + MINL26) / 2, GREATEST((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4, (MAXH52.26 + MINL52.26) / 2))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 9/20/2016 Posts: 11
|
Thank you
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|