Skip to end of banner
Go to start of banner

Calculated Fields

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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

  • There is a differentiation between textual to numeric fields. The user has to select “numeric” or “textual” in the calculated fields toggle, depending on the required calculation. As a result, different fields will be available for each type of calculation engine. Only system parameters which return numeric values will be available in the numeric engine, while in the textual engine all fields will be available (but will be considered as strings).  

  • The engine is case-insensitive when using functions names

Supported Mathematical Functions

  • Basic mathematical functions
    ➕
    ➖
    ✖
    ➗

     

  • Advanced numerical mathematical functions

Function

Explanation

Examples


MIN/MAX

The function will display the smallest/largest number between two or more fields or numbers

Min(unit_id; 1000)

Max(unit_id; 13.5)

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)



IF

The “IF” function is a decision-making condition function between numerical fields.
The function will take its first param and run it in a numeric engine. We can use this feature only inside of an if operation, like this: IF( Num(‘2 > 1’), ‘Yes’, ‘No’ ) -> Yes


IF(unit_id > 1000; 10; 9)

  • Advanced Textual functions

    (warning) You must use a semicolon (;) sign to separate the clauses in the equation instead of a regular comma.

    (warning) 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’)




IF

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




IF('unit_name' = ‘arkadi test’ ; ‘true’ ; ‘false’)


Calculation Field Creation

The process of creating a calculated field is detailed in the following link

  • No labels