Registered User
Joined: 5/9/2014
Posts: 7
|
Hi Bruce/Worden Team,
I have a few variables that have a lot of permutations. I was wondering whether there was a quicker way to generate them? i.e.:
Permuation 1
MAXH10.3>MAXH30.13 AND MAXL10.3>MAXL30.13 AND MAXH2>MAXH2.2
Permuation 2
MAXH11.4>MAXH31.14 AND MAXL11.4>MAXL31.14 AND MAXH3>MAXH3.3
Permuation 3
MAXH12.5>MAXH32.15 AND MAXL12.5>MAXL32.15 AND MAXH4>MAXH4.4
Hope that clarifies the variables + permutations.
I have 2 questions with that context:
Question 1. Can I write a PCF/EasyScan that can scan for Perm 1 OR Perm 2 OR Perm 3 - and show me the results for all in one scan?
Question 2. Is there a way to write the formula itself in a less taxing manner for example MAXH(5 to 50).(3 to 30)>MAXH(30 to 80).(10 to 40)
I'm trying avoid writing the formulas for every permutation. Thanks!
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I cannot think of a way to consodilate the permutations or write in a less taxing manner in this case.
You can place each permutation in parentheses and connect them by OR into a single formula.
(MAXH10.3>MAXH30.13 AND MAXL10.3>MAXL30.13 AND MAXH2>MAXH2.2) OR (MAXH11.4>MAXH31.14 AND MAXL11.4>MAXL31.14 AND MAXH3>MAXH3.3) OR (MAXH12.5>MAXH32.15 AND MAXL12.5>MAXL32.15 AND MAXH4>MAXH4.4)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|