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)