Network Expressions (NEX)
The following functions are now supported in Network Expression Rules.
ABS()
Use to return the absolute value of a number. For example, 5 is returned as 5.
ABS(number)
Examples
| NEX | Result |
|---|---|
| ABS(-4.2) | 4.2 |
| ABS(4.2) | 4.2 |
AT()
Use to retrieve an element in a comma separated list of values, where index = 0 refers to the first element in the array.
AT(list, index)
Examples
| NEX | Result |
|---|---|
| AT(['cd','ed','em','gp','hm','np','on'], 0) | 'cd' |
| AT(['cd','ed','em','gp','hm','np','on'], 2) | 'em' |
| AT(['cd','ed','em','gp','hm','np','on'], 7) | null |
CEIL()
Use to round a number up to the nearest whole number. For example, if the number is 4.1, 5 is returned.
CEIL(number)
Examples
| NEX | Result |
|---|---|
| CEIL(4.1) | 5 |
| CEIL(4) | 4 |
FLOOR()
Use to round a number down to the nearest whole number. For example, if the number is 4.9, 4 is returned.
FLOOR(number)
Examples
| NEX | Result |
|---|---|
| FLOOR(4.9) | 4 |
| FLOOR(4) | 4 |
ROUND()
Use to change a number to the closest whole number. If the number ends in .5 (for example, 4.5), it always rounds up.
ROUND(number)
Examples
| NEX | Result |
|---|---|
| ROUND(3.14) | 3 |
| ROUND(3.5) | 4 |
| ROUND(3) | 3 |
| ROUND(3.14159*10)/10.0 | 3.1 |
| ROUND(3.14159*100)/100.0 | 3.14 |
For all available functions, see NEX functions