Function:
RANDOM
Description:
Calculates randomly generated number as a floating point constant in the range of 0-1
Parameters:
None
Example:
Account.Key = RANDOM
Function:
ABS
Description:
Returns the number constant being an absolute value of the provided number
Parameters:
Attribute of the Number type or number constant or calculation producing number
Example:
If ABS (Transaction.Amount) = 10 Then …
Function:
SIGN
Description:
Returns the sign of the provided number (0, 1 or –1)
Parameters:
Attribute of the Number type or number constant or calculation producing number
Example:
If SIGN (Transaction.Amount) = -1 Then …
Function:
FLOOR
Description:
Returns the largest integer number that is not greater than the provided number: FLOOR (5.67) = 5; FLOOR (-5.57) = -6
Parameters:
Attribute of the Number type or number constant or calculation producing number
Example:
If FLOOR (Transaction.Amount) = 10 Then …
Function:
CEILING
Description:
Returns the smallest integer number that is not less than the provided number: CEILING (5.67) = 6; CEILING (-5.57) = -5
Parameters:
Attribute of the Number type or number constant or calculation producing number
Example:
If CEILING (Transaction.Amount) = 10 Then …
Function:
EXP
Description:
Returns the exponential number raised to the power of the provided number
Parameters:
Attribute of the Number type or number constant or calculation producing number
Example:
If EXP (Transaction.Amount) = 10 Then …
Function:
NEG
Description:
Returns the provided number negated
Parameters:
Attribute of the Number type or number constant or calculation producing number
Example:
If NEG (Transaction.Amount) = -10 Then …
Function:
SQRT
Description:
Calculates the square root of the provided number
Parameters:
Attribute of the Number type or number constant or calculation producing number
Example:
If SQRT (Transaction.Amount) = 10 Then …
Function:
POWER
Description:
Returns the value of the first number raised to the power of the second number
Parameters:
Two attributes of the Number type or number constants or calculations producing number
Example:
If POWER (Transaction.Amount, 2) = 100 Then …
Function:
ROUND
Description:
Returns the first number rounded to the precision of the second number. For example, ROUND (6.738, 1) = 6.7; ROUND (6.738, 2) = 6.74
Parameters:
Two attributes of the Number type or number constants or calculations producing number
Example:
If ROUND (Transaction.Amount, 1) = 10.3 Then …
Function:
MIN2
Description:
Calculates the minimum of the two provided numbers
Parameters:
Two attributes of the Number type or number constants or calculations producing number
Example:
If MIN2 (Transaction.Amount, Account.Balance) = 100 Then …
Function:
MAX2
Description:
Calculates the maximum of the two provided numbers
Parameters:
Two attributes of the Number type or number constants or calculations producing number
Example:
If MAX2 (Transaction.Amount, Account.Balance) = 100 Then …
Function:
MOD
Description:
Calculates the remainder of the first number divided by the second one
Parameters:
Two attributes of the Number type or number constants or calculations producing number
Example:
If MOD (Account.Balance, Transaction.Amount) = 10 Then …