Numeric Functions - trillium_discovery - 17.1

Trillium Expression Builder

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Expression Builder
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

 

The functions for the Numeric category perform calculations on numeric values.

Function Name

Description

ABS

Returns the absolute value of a number.

CEILING

Rounds a decimal number up to the nearest larger integer.

DIVIDEINT

Returns the integer part of the result of a division operation. Non-numeric values will return no results.

FLOOR

Rounds a decimal number down to the nearest smaller integer. Non-numeric values will return no results.

MAX

Returns the larger of two numbers.

MIN

Returns the smaller of two numbers.

MOD

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

PERCENT

Returns the percentage that one number is of another number.

POWER

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

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.

ROUND_05UP

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

ROUND_CEILING

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

ROUND_DOWN

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

ROUND_FLOOR

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

ROUND_HALF_DOWN

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

ROUND_HALF_EVEN

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

ROUND_HALF_UP

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

ROUND_UP

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

SQUARE_ROOT

Returns the square root of a number.

TO_CHAR

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