Supported mathematical functions
Basic math functions: +-*/
Advanced math functions:
MIN
MAX
AVR
ABS
IF
Supported text manipulation functions
...
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.
Basic points
All terms that aren’t supported functions(like If & swap) or operations (like +, (), and params separating commas) must be written inside of single quotes
The engine is case-insensitive when using functions names
We support using single quotes 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
Supported Mathematical Functions
Basic mathematical functions:
➕
➖
✖
➗Advanced mathematical functions:
Function | Explanation | Examples |
|---|---|---|
| The function will display the smallest number between two or more conditions | Min(unit_id, 1000) |
| The function will display the average between two or more conditions |
|
| The ABS function returns the absolute value of the given number, |
|
IF | The “IF” function is a decision-making condition function between numerical/textual fields | Numerical - IF(unit_id > 1000, 10, 9) |
Supported Text Manipulation Functions
Function | Explanation | Examples |
|---|---|---|
SWP | The function will translate a numeric field to a text field | Swap('real_time_status', '0:Down, 999:Off Grid' ) |
Calculation Field Creation
The process of creating calculated field is detailed in the following link