Introduction
...
Basic mathematical functions
➕
➖
✖
➗
Advanced numerical mathematical functions
In numerical formulas, line breaks (Enter) are not permitted, as otherwise the calculation is not
performed and we are left with 0 as a result.
Function | Explanation | Examples |
|---|---|---|
| The function will display the smallest/largest number between two or more fields or numbers | Min(unit_id; 1000) |
AVG | The function will display the average between two or more fields or numbers | AVG(a1; a2; a3; ...) |
ABS | The ABS function returns the absolute value of the given number | ABS(-10) |
| The “IF” function is a decision-making condition function between numerical fields. The following boolean operations are supported in numeric fields: "<", ">", "==", "!=" 0 == 0 -> True 0 != 0 -> False |
|
Advanced Textual functions
All text/string in textual fields must be written inside single quotes, i.e., ‘Text’ (not including function names).
...
Textual fields are case sensitive. For example, CONTAINS(‘OFFGRID’ ; ‘off’) returns false, but CONTAINS(‘OFFGRID’ ; ‘OFF) returns true.
To concatenate several And/Or conditions, add parentheses for each condition, as in the following example: IF(('unit_is_stationary' = 'Yes')&&('unit_is_stationary' = 'Yes'); 'OK';'Not OK')
Single quotes are supported inside a value only by prefixing them with the escape string(\) i.e. a formula
can look like this: 'unit_name' + ' Te\'st' and the result will be unit name Test
...