Calculated Fields

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
MIN/MAX	The function will display the smallest number between two or more conditions	Min(unit_id, 1000) Max(unit_id, 13.5)
AVG	The function will display the average between two or more conditions	AVG(a1, a2, a3, ...)
ABS	The ABS function returns the absolute value of the given number,	ABS(-10)
IF (Numerical & Textual)	The “IF” function is a decision-making condition function between numerical/textual fields	Numerical - IF(unit_id > 1000, 10, 9) Textual - IF('unit_name' = ‘arkadi test’, ‘true’, ‘false’)

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