Registered User
Joined: 10/7/2004
Posts: 11
|
I am trying to create a %True indicator in TC2007 using the formula:
(100 * (C - MAXH10) / (MAXH10 - MINL10)) > -25 AND (100 * (C1 - MAXH10.1) / (MAXH10.1 - MINL10.1)) < -25
The indicator should show me when the calculated value crosses above -25. The calculations work prefectly on a spreadsheet and should show 100% when the condition occurs.
What am I doing wrong that I get an error that this formula is not a Boolean Formula.
I appreciate the help.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Your formula would probably work in TC2000 version 12, but TC2000 version 7 doesn't understand the -25 as written (it sees it as subtraction instead of a negative sign). You need to either put it in parentheses:
100 * (C - MAXH10) / (MAXH10 - MINL10) > (-25) AND 100 * (C1 - MAXH10.1) / (MAXH10.1 - MINL10.1) < (-25)
Or subtract the 25 from zero:
100 * (C - MAXH10) / (MAXH10 - MINL10) > 0 - 25 AND 100 * (C1 - MAXH10.1) / (MAXH10.1 - MINL10.1) < 0 - 25
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: 10/7/2004
Posts: 11
|
Thanks Bruce
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|