Numeric Functions in Quick BI - Quick BI - Alibaba Cloud - Quick BI

Numeric functions process numerical data by applying mathematical rules to input values and returning new numerical results.

BI_ABS

BI_ABS calculates the absolute value of a number.

Syntax	BI_ABS(number)
Description	number: the number whose absolute value you want to obtain.
Description	Returns the absolute value of <number>.
Output data type	N/A
Examples	BI_ABS(-1.5) = 1.5

BI_CEILING rounds a number up to the nearest integer.

Syntax	BI_CEILING(number)
Description	number: the numeric value to be rounded.
Description	Rounds up to the smallest integer that is greater than or equal to a number.
Output data type	Integer
Examples	BI_CEILING(2.5) = 3

BI_EXP calculates e raised to the power of the specified number. The constant e is the base of the natural logarithm, approximately equal to 2.71828.

Syntax	BI_EXP(number)
Description	number: any real number that is used as the exponent of the constant e.
Description	Returns e raised to the <number> power.
Output data type	N/A
Examples	BI_EXP(2) = 7.389

BI_FLOOR rounds a number down to the nearest integer.

Syntax	BI_FLOOR(number)
Description	number: the numeric value to be rounded.
Description	Rounds down to the greatest integer that is smaller than or equal to a number.
Output data type	Integer
Examples	BI_FLOOR(7.9) = 7

BI_GREATEST returns the maximum value from a list of parameters.

Syntax	BI_GREATEST(value1, value2, ...)
Description	value1, value2, ...: the values to compare.
Description	Returns the maximum value among multiple parameters. Enter at least two parameters.
Output data type	N/A
Examples	BI_GREATEST(10, 5, 7) = 10

BI_LEAST returns the minimum value from a list of parameters.

Syntax	BI_LEAST(value1, value2, ...)
Description	value1, value2, ...: the values to compare.
Description	Returns the minimum value among multiple parameters. Enter at least two parameters.
Output data type	N/A
Examples	BI_LEAST(10, 5, 7) = 5

BI_POWER raises a number to a specified power.

Syntax	BI_POWER(number, power)
Description	number: the base number. power: the exponent to which the number is raised.
Description	Returns the <power> power of <number>.
Output data type	N/A
Examples	BI_POWER(5,3) = 125

BI_ROUND rounds a number to the specified number of decimal places.

Syntax	BI_ROUND(number, [decimals])
Description	number: the number to be rounded. [decimals]: the number of decimal places to round to. If less than 0, the number is rounded to the left of the decimal point. If equal to 0 or omitted, the number is rounded to the nearest integer. If greater than 0, the number is rounded to the specified decimal place.
Description	Rounds <number> to the specified number of decimal places. <decimals> specifies the number of decimal places in the output. If decimals is omitted, the output is an integer.
Output data type	N/A
Examples	BI_ROUND(1/3, 2) = 0.33

BI_SQRT calculates the square root of a number.

Syntax	BI_SQRT(number)
Description	number: the number whose square root you want to calculate.
Description	Returns the square root of <number>.
Output data type	N/A
Examples	BI_SQRT(25) = 5

BI_SQUARE calculates the square of a number.

Syntax	BI_SQUARE(number)
Description	number: the number to be squared.
Description	Returns the square of <number>.
Output data type	N/A
Examples	BI_SQUARE(5) = 25