Page Comparison

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)

SWPSWAP

The function will translate 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’)