There are a few pseudo-variables which have special functions in the expression language. The following specials are column-like, in that they have a different value for each row:
long
(8-byte integer);
when using it in certain expressions you may find it necessary to convert
it to an int
(4-byte integer) using the
toInteger()
function.
The deprecated alias "INDEX
" may also be used.
0<=x<1
.
NOTE: this token is deprecated since it can behave
unpredictably (the same cell does not always yield the same result).
Use instead the random()
function in class
Maths.
The following specials are parameter-like, in that their value is not sensitive to the row:
long
(8-byte integer);
when using it in certain expressions you may find it necessary to convert
it to an int
(4-byte integer) using the
toInteger()
function.