INT- FineBI Help Document

Last update：December 19, 2024

Extracted Data

1. Overview

Syntax	*INT(Number)*	Rounds a number down to the nearest integer.
Parameter	Number	Represents a real number that needs to be rounded down to the nearest integer.

2. Notes

The function supports only one numeric or text parameter and will be illegal if more than one numeric or string parameters are set.

3. Example

Sample data: Product Sales Table.xlsx

In the Product Sales Table, use the INT function to round the sales down to the nearest integers.

Click Formula Column in the analysis subject, set Name of Added Formula Column to Rounded-down Sales Volume, enter INT(Sales Volume), and click OK, as shown in the following figure.

The rounded-down sales volumes appear in the data table, as shown in the following figure.

The following table shows more examples.

Formula	Result	Note
INT(4.8)	4
INT(-4.8)	–5
INT(4.3)	4
INT(-4.3+5)	0

Real-Time Data

1. Overview

Syntax	*INT(Number)*	Rounds a number to the nearest integer toward zero.
Parameter	Number	Represents a real number that needs to be rounded to integers.

2. Notes

The function supports only one numeric parameter and will be illegal if more than one numeric parameters are set.

3. Example

Formula	Result	Note
INT(4.8)	4
INT(-4.8)	–4
INT(4.3)	4
INT(-4.3+5)	0

Helpful
Not helpful
Only read

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

English

INT

Extracted Data

Real-Time Data

附件列表