ABS 
Returns the absolute value of a number.
 Syntax

ABS(number)
where number is the number for which you want the absolute
value.
 Examples

 ABS(1.123) returns the value 1.123.
 ABS(45) returns the value 45.0.

CEILING

Rounds a decimal number up to the nearest larger integer.
 Syntax

CEILING(number)
where number is the decimal number you want to round up.
 Examples

 CEILING(1.123) returns 2.0.
 CEILING(45) returns 45.0.

DIVIDEINT

Returns the integer part of the result of a division operation. Nonnumeric
values will return no results.
 Syntax

DIVIDEINT(number1,number)
where number1 is the decimal number you are dividing and
number is the decimal number you are diving with.
 Examples

 DIVIDEINT(2.24,2) returns 1
 DIVIDEINT(4.68,2.10) returns 2

FLOOR 
Rounds a decimal number down to the nearest smaller integer. Nonnumeric
values will return no results.
 Syntax

FLOOR(number)
where number is the decimal number you want to round
down.
 Examples

 FLOOR(1.123) returns 1.0.
 FLOOR(45) returns 45.0.
 FLOOR($45.00) returns no value.
Note: In the last example, you get no result because of the $
sign.

MAX

Returns the larger of two numbers.
 Syntax

MAX(number1,number2)
where number1 and number2 are the decimal numbers you
are comparing.
 Examples

MAX(4.36,9.32) returns 9.32

MIN

Returns the smaller of two numbers.
 Syntax

MIN(number1,number2)
where number1 and number2 are the decimal numbers you
are comparing.
 Examples

MIN(4.36,9.32) returns 4.36

MOD

Returns the decimal remainder of the division of one number by another.
 Syntax

MOD(number1,number2)
where:

number1 is the number to be divided.

number2 is the number by which number1 is
divided.
 Examples

 MOD(94,9) returns the remainder 4.0.
 MOD(4.5,2) returns the remainder 0.5.
 MOD(7.1,2) returns the remainder 1.12.

PERCENT

Returns the percentage that one number is of another number.
 Syntax

PERCENT(number1
,number2)
where:

number1 is the part of the whole number used to calculate
the percentage.

number2 is the whole number.
 Examples

 PERCENT(48,12) returns the percentage 25.0.
 PERCENT(3,3) returns the percentage 100.0.
 PERCENT(81,2) returns the percentage 2.46913580247.

POWER

Calculates the values of one number raised to the power of another.
 Syntax

POWER(number1,number2)
where:

number1 is the base number.

number2 specifies the exponent of the power to use in the
calculation.
 Examples

 POWER(4,4) returns 256.0.
 POWER(3,2) returns 9.0.
 POWER(4.8122,2) returns 23.15726884.

ROUND

Rounds a decimal number to its nearest integer. Supports an numeric
parameter that returns the integers following the decimal, up to the
specified numeric. This is useful to ensure accurate calculations of amounts
involving currency.
 Syntax

ROUND(number,digits)
where

number is the number you want to round to its nearest
integer.

digits is the number of places after the decimal point
you want to return.
 If digits is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND(19.5) returns 20.
 ROUND(45) returns 45.
 ROUND(1.567) returns 2.
 ROUND(71002/610) returns 116.
 ROUND(71002/610,6) returns 116.396721.
 ROUND(71013/412,6) returns 172.36165 (last number is a
zero).
 ROUND(3.235, 3) returns 3.235

ROUND_05UP

Rounds up a decimal number to its nearest integer only if the number to be
rounded is either 0 or 5.
 Syntax

ROUND_05UP(number,digits)
where

number is the number you want to round up to its nearest
integer.

digits is the number of places after the decimal point
you want to return.
 If digits is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_05UP(8.59,1) returns 8.6
 ROUND_05UP(8.504,2) returns 8.51
 ROUND_05UP(3.235, 3) returns 3.235

ROUND_CEILING

Rounds up a decimal number to the nearest integer with a bias towards
infinity.
 Syntax

ROUND_CEILING(number, digits)
where

number is the number you want to round up to its nearest
integer.

digits is the number of places after the decimal point
you want to return.
 If precision is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_CEILING(3.82, 1) returns 3.8
 ROUND_CEILING(3.82, 1) returns 3.9
 ROUND_CEILING(3.235, 3) returns 3.235

ROUND_DOWN

Rounds down a decimal number to its nearest integer with a bias towards 0.
 Syntax

ROUND_DOWN(number,digits)
where

number is the number you want to round down to its
nearest integer.

digits is the number of places after the decimal point
you want to return.
 If precision is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_DOWN(4.7,0) returns 4
 ROUND_DOWN(4.579,2) returns 4.57
 ROUND_DOWN(3.235, 3) returns 3.235

ROUND_FLOOR

Rounds down a decimal number to its nearest integer with a bias towards
negative infinity.
 Syntax

ROUND_FLOOR(number,digits)
where

number is the number you want to round down to its
nearest integer.

digits is the number of places after the decimal point
you want to return.
 If precision is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_FLOOR(3.82,1) returns 3.8
 ROUND_FLOOR(3.82,1) returns 3.9
 ROUND_FLOOR(3.235, 3) returns 3.235

ROUND_HALF_DOWN

Rounds down a decimal number to the nearest integer. If equidistant (0.5),
round down.
 Syntax

ROUND_HALF_DOWN(number,digits)
where

number is the number you want to round down to its
nearest integer.

digits is the number of places after the decimal point
you want to return.
 If precision is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_HALF_DOWN(3.2,0) returns 3
 ROUND_HALF_DOWN(4.55,1) returns 4.5
 ROUND_HALF_DOWN(3.235, 3) returns 3.235

ROUND_HALF_EVEN

Rounds a decimal number to the nearest integer. If equidistant (0.5), round,
so the result is an even number.
 Syntax

ROUND_HALF_EVEN(number,digits)
where

number is the number you want to round to its nearest
integer.

digits is the number of places after the decimal point
you want to return.
 If precision is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_HALF_DOWN(8.25,1) returns 8.2
 ROUND_HALF_DOWN(4.55,1) returns 4.6
 ROUND_HALF_DOWN(3.235, 3) returns 3.235

ROUND_HALF_UP

Rounds up a decimal number to the nearest integer. If equidistant (0.5),
round up.
 Syntax

ROUND_HALF_UP(number,digits)
where

number is the number you want to round up to its nearest
integer.

digits is the number of places after the decimal point
you want to return.
 If precision is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_HALF_UP(4.55685,4) returns 4.5569
 ROUND_HALF_UP(4.55,1) returns 4.6
 ROUND_HALF_UP(3.235, 3) returns 3.235

ROUND_UP

Rounds up a decimal number to its nearest integer with a bias away from 0.
 Syntax

ROUND_UP(number,digits)
where

number is the number you want to round up to its nearest
integer.

digits is the number of places after the decimal point
you want to return.
 If precision is zero (0), the result will be a number
with no decimal place.
 If the last number in the result is zero (0), it will not
be displayed.
 If the value for digits matches the precision of the
value, no rounding is performed.
 Examples

 ROUND_UP(3.224,2) returns 3.23
 ROUND_UP(4.573,1) returns 4.6
 ROUND_UP(3.235, 3) returns 3.235

SQUARE_ROOT

Returns the square root of a number.
 Syntax

SQUARE_ROOT(number)
where number is the number for which you want the square
root.
 Examples

 SQUARE_ROOT(81) returns 9.0.
 SQUARE_ROOT(3) returns 1.73205080757.
 SQUARE_ROOT(4.8122) returns 2.19367271944.

TO_CHAR

Returns a number formatted to n decimal places with a localized
decimal point.
 Syntax

TO_CHAR(number,decimal)
where:

number is the number for which you want the absolute
value.

decimal is the number of decimal places to use.
 Example

TO_CHAR(1.23,3) returns 1.230, or in German locale 1,230.
