Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/8/2005 Posts: 23
|
I'm having trouble getting this PCF to work. I note the first or second part work alone but together they produce nothing. Could you tell me where I went wrong?
H=maxh30 and H1<maxh29.1 and H2<maxh28.2 and H3<maxh27.3 and H4<maxh26.4 and H5<maxh25.5 and H6<maxh24.6 and h7<maxh23.7 and h8<maxh22.8 and h9<maxh21.9 and h10<maxh20.10 and h11<maxh19.11 and h12<maxh18.12 and h13<maxh17.13 and h14<maxh16.14 and h15<maxh15.15 and h16<maxh14.16 and h17<maxh13.17 and h18<maxh12.18 and h19<maxh11.19 and h20<maxh10.20 or
H1=maxh29.1 and H2<maxh28.2 and H3<maxh27.3 and H4<maxh26.4 and H5<maxh25.5 and H6<maxh24.6 and h7<maxh23.7 and h8<maxh22.8 and h9<maxh21.9 and h10<maxh20.10 and h11<maxh19.11 and h12<maxh18.12 and h13<maxh17.13 and h14<maxh16.14 and h15<maxh15.15 and h16<maxh14.16 and h17<maxh13.17 and h18<maxh12.18 and h19<maxh11.19 and h20<maxh10.20
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The issue is that H1 < MAXH29.1 can't be true because H1 is part of MAXH29.1 (and the same issue continues with all of the rest of the terms).
You probably want something more like the following:
((H = MAXH30 AND H1 < MAXH28.2) OR H1 = MAXH29.1) AND H2 < MAXH27.3 AND H3 < MAXH26.4 AND H4 < MAXH25.5 AND H5 < MAXH24.6 AND H6 < MAXH23.7 AND H7 < MAXH22.8 AND H8 < MAXH21.9 AND H9 < MAXH20.10 AND H10 < MAXH19.11 AND H11 < MAXH18.12 AND H12 < MAXH17.13 AND H13 < MAXH16.14 AND H14 < MAXH15.15 AND H15 < MAXH14.16 AND H16 < MAXH13.17 AND H17 < MAXH12.18 AND H18 < MAXH11.19 AND H19 < MAXH10.20 AND H20 < MAXH9.21
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/8/2005 Posts: 23
|
Thanks Bruce, but I'm a little confused with your use of parentheses. You use two at the beginning and only one thereafter. That's probably just a typo. But then, why would you use parentheses at all in this formula? It doesn't seem to change anything. Additionally, I've found that even after making the other changes, the formula before the 'or' and the formula after the 'or' produce different results which aren't combined when I use the 'or'.
|
|
Registered User Joined: 3/8/2005 Posts: 23
|
Oops! I'm sorry. I missed the second parentheses.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Order of operations:
*,/
+,-
>,>=,<,<=,=,<>
OR
AND
() -> Parentheses will force an operation to perform earlier in the order.
So if you want ANDs to be processed before ORs, you need to use parantheses to force the order of operations.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |