Numeric Functions - trillium_discovery - trillium_quality - Latest

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.

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.

Returns the integer part of the result of a division operation. Non-numeric 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

Rounds a decimal number down to the nearest smaller integer. Non-numeric 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.

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

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

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.

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.

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.

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

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

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

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

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

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

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

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

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

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.