Page Comparison

...

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 it’s first param and run it in a numeric engine. We can use this feature only inside of an if operations, like this: IF( Num(‘2 > 1’), ‘Yes’, ‘No’ ) -> Yes	IF(unit_id > 1000., 10., 9)

Function

Explanation

Examples

SWP

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

...

Versions Compared