Gold Customer
Joined: 12/1/2004 Posts: 137
|
Dear Bruce,
When I create the following PCF, I get this syntax error message: "Unmatched Parenthesis at Position 509". Could you pls figure out where the missing parenthesis is and correct it. thks. Chopee
(TSV10 > ((TSV10 + TSV10.1 + TSV10.2 + TSV10.3 + TSV10.4 + TSV10.5 + TSV10.6 + TSV10.7 + TSV10.8 + TSV10.9 + TSV10.10 + TSV10.11 + TSV10.12) / 13)) AND
(TSV10.1 < ((TSV10.1 + TSV10.2 + TSV10.3 + TSV10.4 + TSV10.5 + TSV10.6 + TSV10.7 + TSV10.8 + TSV10.9 + TSV10.10 + TSV10.11 + TSV10.12 + TSV10.13) / 13)) AND
MS > MS10 AND MS1.1 < MS10.1 AND
TSV28 > ((TSV15 + TSV15.1 + TSV15.2 + TSV15.3 + TSV15.4 + TSV15.5 + TSV15.6 + TSV15.7 + TSV15.8 + TSV15.9 + TSV15.10 + TSV15.11 + TSV15.12 + TSV15.13 + TSV15.14) / 15)) AND
TSV28.3 < ((TSV15.3 + TSV15.4 + TSV15.5 + TSV15.6 + TSV15.7 + TSV15.8 + TSV15.9 + TSV15.10 + TSV15.11 + TSV15.12 + TSV15.13 + TSV15.14 + TSV15.15 + TSV15.16 + TSV15.17) / 15)) AND
(TSV38 > ((TSV38 + TSV38.1 + TSV38.2 + TSV38.3 + TSV38.4 + TSV38.5 + TSV38.6 + TSV38.7 + TSV38.8 + TSV38.9 + TSV38.10 + TSV38.11 + TSV38.12 + TSV38.13 + TSV38.14 + TSV38.15 + TSV38.16 + TSV38.17 + TSV38.18) / 19)) AND
(TSV38.1 < ((TSV38.1 + TSV38.2 + TSV38.3 + TSV38.4 + TSV38.5 + TSV38.6 + TSV38.7 + TSV38.8 + TSV38.9 + TSV38.10 + TSV38.11 + TSV38.12 + TSV38.13 + TSV38.14 + TSV38.15 + TSV38.16 + TSV38.17 + TSV38.18 + TSV38.19) / 19)) AND
AVGV50 > 3000 AND
C > 2 AND
C < 40
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You are either missing an opening parenthesis or have an extra closing parenthesis in both the fourth and fifth sections of your formula. Since the parentheses in question are not necessary to the formula, I removed the both to create the following.
(TSV10 > ((TSV10 + TSV10.1 + TSV10.2 + TSV10.3 + TSV10.4 + TSV10.5 + TSV10.6 + TSV10.7 + TSV10.8 + TSV10.9 + TSV10.10 + TSV10.11 + TSV10.12) / 13)) AND
(TSV10.1 < ((TSV10.1 + TSV10.2 + TSV10.3 + TSV10.4 + TSV10.5 + TSV10.6 + TSV10.7 + TSV10.8 + TSV10.9 + TSV10.10 + TSV10.11 + TSV10.12 + TSV10.13) / 13)) AND
MS > MS10 AND MS1.1 < MS10.1 AND
TSV28 > ((TSV15 + TSV15.1 + TSV15.2 + TSV15.3 + TSV15.4 + TSV15.5 + TSV15.6 + TSV15.7 + TSV15.8 + TSV15.9 + TSV15.10 + TSV15.11 + TSV15.12 + TSV15.13 + TSV15.14) / 15) AND
TSV28.3 < ((TSV15.3 + TSV15.4 + TSV15.5 + TSV15.6 + TSV15.7 + TSV15.8 + TSV15.9 + TSV15.10 + TSV15.11 + TSV15.12 + TSV15.13 + TSV15.14 + TSV15.15 + TSV15.16 + TSV15.17) / 15) AND
(TSV38 > ((TSV38 + TSV38.1 + TSV38.2 + TSV38.3 + TSV38.4 + TSV38.5 + TSV38.6 + TSV38.7 + TSV38.8 + TSV38.9 + TSV38.10 + TSV38.11 + TSV38.12 + TSV38.13 + TSV38.14 + TSV38.15 + TSV38.16 + TSV38.17 + TSV38.18) / 19)) AND
(TSV38.1 < ((TSV38.1 + TSV38.2 + TSV38.3 + TSV38.4 + TSV38.5 + TSV38.6 + TSV38.7 + TSV38.8 + TSV38.9 + TSV38.10 + TSV38.11 + TSV38.12 + TSV38.13 + TSV38.14 + TSV38.15 + TSV38.16 + TSV38.17 + TSV38.18 + TSV38.19) / 19)) AND
AVGV50 > 3000 AND
C > 2 AND
C < 40
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 12/1/2004 Posts: 137
|
Thanks Bruce
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|