Overview of Other Functions- FineBI Help Document

Last update：December 26, 2024

Usage Scope

	Position
Editing data	Adding a column and filtering
Component	Adding a calculation field

Function List

Function	Usage	Example
ISNULL	Returns a specified value if the object is NULL or empty.	*ISNULL(Clock-in time): 1 is returned if Clock-in time* is NULL or empty and 0 is returned if *Clock-in time* is not NULL or empty.
NVL	Returns the first value that is not null among all parameter values.	NVL(12,20) returns 12. NVL(Null,12) returns 12. NVL(Null,Null) returns Null.

Function

Usage

Example

ISNULL

Returns a specified value if the object is NULL or empty.

ISNULL(Clock-in time): 1 is returned if Clock-in time is NULL or empty and 0 is returned if Clock-in time is not NULL or empty.

NVL

Returns the first value that is not null among all parameter values.

NVL(12,20) returns 12.

NVL(Null,12) returns 12.

NVL(Null,Null) returns Null.

Previous：NVL

Next：ISNULL - Determining Whether an Object is Null

Helpful
Not helpful
Only read

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

English

Overview of Other Functions

Usage Scope

Function List

附件列表