Versions Compared

Old Version 10

changes.mady.by.user arkadi kaplon

Saved on

compared with

New Version 11

changes.mady.by.user External Share for Confluence

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 static text/strings that aren’t supported functions (like If & swap) or operations (like +, (), and params separating commas)  must be written inside of single quotesThere 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

    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
    ➕
    ➖
    ✖
    ➗
    Simple concatenation function, using the plus sign. i.e. : 'Daniel unit' + ' Test'
     -> Daniel Unit Test.

  • Advanced numerical 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

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

...