Show TOC

 Check Formula Syntax for Input Validations Locate this document in the navigation structure

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

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

End of the note.

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