INT- FineBI Document

Last update： 2022-04-08

1. Extract data

1）Overview

Grammar	INT(number)	Returns the nearest integer value after the number is rounded down (the direction in which the value decreases).
Parameter	number	Real numbers that need to be rounded down to integers.

2）Matters needing attention

One numeric / text parameter is supported, and more than one is illegal.

3）Example

Use the "Group Product Sales Summary Table" under the "First Dashboard" to round the sales down to the nearest whole number.

Click "New column" in the self-service dataset, name it, enter the formula INT(Sales) and click "OK", as shown in the following figure:

Note: The functions and fields in the formula box need to be selected by clicking the selection area on the left, and cannot be entered manually.

Sales rounded down appear in the self-service dataset, as shown in the following figure:

More examples are as follows:

1）Overview

Grammar	INT(number)	Returns the integer whose number is closest to 0.
Parameter	number	Real numbers that need to be rounded to integers.

2）Matters needing attention

One numeric parameter is supported, and more than one is illegal.

3）Example

Next：ABS

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

English