34.4.3 Additional Functions

As well as system defined Functions, the Formula Results Rule also utilizes the standard mathematical, logical and relational operands and functions.

Mathematical Functions

Table 34-16 Mathematical Functions

Function	Description
Abs	Returns the positive value of the expression.
	Example: Abs(-3.5) = 3.5.
Greatest:	Allows you to return the maximum value of the expression.
	Syntax: Greatest(Expr, Expr).
Least:	Allows you to return the minimum value of the expression.
	Syntax: Least(Expr, Expr).
Power:	Allows you to raise one value to the power of a second.
	Syntax: Power(x, y) returns x raised to the power of y.
Round:	Allows you to round a value to a number of decimal places.
	Syntax: Round(x, n) returns x rounded to n decimal places.
Log:	Allows you to calculate the log of the expres­sion
	Syntax: Log(x, n) returns the n log of x.
Case:	Allows you to define if conditionals.
	Syntax: case when 21>12 then 21 else 12 end

Relational Operators

Table 34-17 List of supported Relation Operators

Operator	Description
=	Equal to
<>	Not Equal to
>	Greater than
<	Less than
>=	Greater than or Equal to
<=	Less than or Equal to

Numeric Operators

Table 34-18 List of supported Numeric Operators

Operator	Description
+	Addition
-	Subtraction
*	Multiplication
/	Division

Logical Operators

Table 34-19 List of supported Logical Operators

Operand	Description
AND	Both conditions must be true
OR	Either condition can be true

Other Operators

Table 34-20 List of supported Other Operators

Operand	Description
(	Open paren
)	Close paren
,	Comma