Check formulas in input validation must have the following syntax:
<relational expression><logical operator><relational expression>
<rel.expression> = <arith.expression><rel.operator><arith.expression>
Note the following:
You can use the operators listed below.
You can enter any number of logical relationships in a check formula.
In relational expressions, you can use variable X for the input value.
You must always use the decimal point for decimal numbers.
You can use variables to transfer numeric values of preceding process instructions to the check formula.
For more detailed information see:
In long formulas, you may use no more than 240 characters that can be separated in any number of lines.
Note
Note that a blank character is automatically set at the end of each line. For this reason, make sure to write long number, variable names, or operators together in one line.
( )
PPPI_VALIDATION_FORMULA x>50 AND x<100 OR
PPPI_VALIDATION_FORMULA x<200 AND x>150
Logical Operators |
Meaning |
AND |
Both of the linked expressions have to be true. |
OR |
One of the linked expressions has to be true. |
NOT |
The expressions following the operator must not be true. |
Relational Operators |
Meaning |
= |
Equal to |
<= |
Less than or equal to |
>= |
Greater than or equal to |
<> |
Not equal to |
>< |
Not equal to |
< |
Less than |
> |
Greater than |
Arithmet. Operators |
Meaning |
+ |
Plus |
- |
Minus |
* |
Multiplied by |
/ |
Divided by |
DIV |
Modulo division; division where the result is quoted as an integer |
MOD |
Remainder after modulo division |
ABS |
Absolute value |
SIN |
Sine |
COS |
Cosine |
TAN |
Tangent |
LOG |
Logarithm to base e |
** |
To the power of |
EXP |
Power to base e |
SQRT |
Square root |
ROUND |
Round to nearest integer |
TRUNC |
Cut off decimals |