 Gold Customer
Joined: 3/11/2013
Posts: 24
|
I have what I consider to be a complex PCF need. I think it might be doable using nested IIF and Greatest functions but have not had luck so far. Here is the logic:
Group A:
A1) ABS(C2-L1)
A2) ABS(C2-H1)
A3 H1-L1
Group B:
B1) ABS(C1-L)
B2) ABS(C1-H)
B3) H-L
Scan1= Largest Group B value is 25% bigger than the largest Group A value
Scan2= Largest Group B value is 25% smaller than the largest Group A value
Can anyone lend a hand?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following formulas are for TC2000 v18.
Scan1:
GREATEST(ABS(C1 - L), ABS(C1 - H), H - L) >= 1.25 * GREATEST(ABS(C2 - L1), ABS(C2 - H1), H1 - L1) AND (H <> L OR H <> C1 OR L <> C1)
Scan2:
GREATEST(ABS(C1 - L), ABS(C1 - H), H - L) <= .75 * GREATEST(ABS(C2 - L1), ABS(C2 - H1), H1 - L1) AND (H1 <> L1 OR H1 <> C2 OR L1 <> C2)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|