Overview of mathematics and trigonometric functions- FineBI Document

Last update： 2023-05-15

1. Overview

1.1 Use location

	Use location	Using field types
Self-service Dataset	Add new column、Filter	Numeric fields (some functions allow adding some specified parameter values)
Dashboard	Add calculated fields

2. Function list

Function	Description
RAND	Returns a uniformly distributed random number. Each time the worksheet is calculated, the function returns a new random value.
SQRT	Returns the square root of an arithmetic number that is not negative. You can find any non-negative number that is the square root of an arithmetic number.
LOG10	Returns the logarithm with a base of 10.
FLOOR	Round the parameter number to the end in the direction of decreasing absolute value.
LOG	Returns the logarithm of the value by any base number specified.
MAX	Returns the maximum value in the parameter list
MIN	Returns the minimum value in the parameter list
TRUNC	Truncates a number by a certain number of digits and returns an integer or decimal.
FACT	Returns the factorial of a number. The factorial of a number is equal to 123... number
RANDBETWEEN	Returns a random integer between value1 and value2
LN	Returns the natural logarithm of a number. The natural logarithm is underlain by the constant term e(2.71828182845904).
SIGN	Returns the sign of the number. Returns 1 when the number is positive, 0 when it is zero, and -1 when it is negative
CEILING	Rounds the parameter number to the nearest integer along the direction of increasing absolute value.
MOD	Returns the remainder of the division of two numbers. The positive and negative signs of the result are the same as the divisor.
PROMOTION	Returns the percentage of value2 lifted over value1
EXP	Returns the nth power of e. The constant e is the base of the natural logarithm and is equal to 2.171828182845904.
ACOS	Returns the inverse cosine of the specified value. The inverse cosine value is an angle, and the return angle is expressed in radians.
ASIN	Returns the inverse sine of the specified value. The inverse sine value is an angle, and the return angle is expressed in radians.
ATAN	Calculates the arctangent of the specified value. The specified value is the tangent of the returned angle, and the returned angle is expressed in radians.
ATAN2	Returns the arctangent of the x and y coordinates. Returns the angle formed by the x-axis and a line through (x_num,y_num) with the coordinate origin (0,0).
COS	Returns the cosine of an angle.
DEGREES	Converts radians into degrees.
PI	A mathematical constant
POWER	Returns the multiplication power of the specified number
RADIANS	Convert angles to radians
SIN	Calculate the sine of a given angle
TAN	Returns the tangent of the specified angle

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

Overview of mathematics and trigonometric functions

1. Overview

1.1 Use location

2. Function list

附件列表