Registered User
Joined: 3/27/2012
Posts: 9
|
Can you help with the syntax for the above condition? (True or False)
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Condition Formula for a Simple TSV18:
10 * TSV18 > 4 * TSV18.1 + 3 * TSV18.2 + 2 * TSV18.3 + TSV18.4 AND TSV18 > TSV18.1 AND 10 * TSV18.1 > 4 * TSV18.2 + 3 * TSV18.3 + 2 * TSV18.4 + TSV18.5 AND TSV18.1 > TSV18.2 AND 10 * TSV18.2 > 4 * TSV18.3 + 3 * TSV18.4 + 2 * TSV18.5 + TSV18.6 AND TSV18.2 > TSV18.3 AND 10 * TSV18.3 > 4 * TSV18.4 + 3 * TSV18.5 + 2 * TSV18.6 + TSV18.7 AND TSV18.3 > TSV18.4
And the following Condition Formula for an Exponential TSV18:
10 * XAVG(TSV,18) > 4 * XAVG(TSV1.1,18) + 3 * XAVG(TSV1.2,18) + 2 * XAVG(TSV1.3,18) + XAVG(TSV1.4,18) AND XAVG(TSV,18) > XAVG(TSV1.1,18) AND 10 * XAVG(TSV1.1,18) > 4 * XAVG(TSV1.2,18) + 3 * XAVG(TSV1.3,18) + 2 * XAVG(TSV1.4,18) + XAVG(TSV1.5,18) AND XAVG(TSV1.1,18) > XAVG(TSV1.2,18) AND 10 * XAVG(TSV1.2,18) > 4 * XAVG(TSV1.3,18) + 3 * XAVG(TSV1.4,18) + 2 * XAVG(TSV1.5,18) + XAVG(TSV1.6,18) AND XAVG(TSV1.2,18) > XAVG(TSV1.3,18) AND 10 * XAVG(TSV1.3,18) > 4 * XAVG(TSV1.4,18) + 3 * XAVG(TSV1.5,18) + 2 * XAVG(TSV1.6,18) + XAVG(TSV1.7,18) AND XAVG(TSV1.3,18) > XAVG(TSV1.4,18)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|