Introduction
The calculated fields feature allows you to make calculations on numeric and textual fields inside the report itself, so there is no obligation to export the report to Excel. In addition, there is full support for filtering the fields according to the calculation results.
This feature can also be used in schedule reports, saved as favorites, etc.
...
Function | Explanation | Examples |
|---|---|---|
| The function will display the smallest number between two or more conditions | Min(unit_id; 1000) |
AVG | The function will display the average between two or more conditions |
|
ABS | The ABS function returns the absolute value of the given number |
|
| The “IF” function is a decision-making condition function between numerical fields. |
|
Advanced Textual functions
You must use a semicolon (;) sign to separate the clauses in the equation instead of a regular comma. The "combined" condition must be accompanied by parentheses in order for it to function properly.
IF(('unit_is_stationary' = 'Yes') && ('unit_is_stationary' = 'Yes'); 'OK';'Not OK')
Function | Explanation | Examples |
|---|---|---|
SWAP | The function will convert a numeric field to a text field | Swap(’real_time_status’ ; ‘0:Down’ ; ’999:Off Grid’) |
| The “IF” function is a decision-making condition function between textual fields. IF operation – syntax: IF(‘a’ ; ’b’ ; ‘c’) -> if “a” is true then “b” else “c”. We support the following Boolean operations in text fields: ‘a’ = ‘a’ -> True ‘a’ != ‘a’ -> False |
|
...