...
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 static text/strings 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
...
Basic mathematical functions:
➕
➖
✖
➗
Simple concatenation function, using the plus sign. i.e. : 'Daniel unit' + ' Test' -> Daniel unit Test.Advanced numerical mathematical functions:
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 |
. |
|
Textual
...
Supported Text Manipulation Functions
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' ) |
| The “IF” function is a decision-making condition function between textual fields. IF operation – syntax: IF(‘a’,’b’,‘c’) -> if “a” is true than “b” else “c”. We support the following Boolean operations in text fields: ‘a’ = ‘a’ -> True ‘a’ != ‘a’ -> False |
|
Calculation Field Creation
...