After you create a new element, you can define the expression:
-
Select the element for which you want to enter (or edit) the expression. The pane on the right is showing the expression of the selected element. The syntax can contain logic interconnections / references to data tables, mathematical functions / operations and conditions.
-
Enter the expression in the Expression Editor.
-
The element expression consists of:
-
Variables – Can refer to a value of another element using its name.
-
Functions – See Formula Functions.
-
Number expressions – Resulting in either integer or BigDecimal (not double/float).
-
String expressions
-
String literals – Literal strings have to be quoted using the double quotes (").
-
-
Operators:
Brackets
( )
Less than or equal to
<=
Plus
+
Equal
=
Minus
-
Not equal
<>
!=
Multiply
*
And
and
Divide
/
Or
or
Modulo
%
Not
not
Power
^
Binary inversion
inv
Greater than
>
Bitwise exclusive or
xor
Greater than or equal to
>=
Binary and
&
Less than
<
Binary or
|
-
Save the expression.