Mathematical Functions

UDP ›› Functions ››
Parent Previous Next

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 …