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)