ROUND- FineBI Document

Last update： 2022-04-08

1. Overview

Grammar	ROUND(number,num_digits)	Returns a number rounded by a specified number of digits.
Parameter1	number	The number to be rounded.
Parameter2	num_digits	Rounding is performed according to this number of digits. If it is less than 0, it is rounded to the left of the decimal point. Equal to 0, then round to the nearest integer. If it is greater than 0, it will be rounded to the specified decimal place.

2. Matters needing attention

Supports two numerical parameters.

3. Examples

Use the "FRDemo_MainlandCarSale" under "FRDemo" and "The Sales volume (ten thousand vehicles)" needs to be rounded to one decimal place.

Click "New column" in the self-service dataset, name it, enter the formula ROUND(Sales volume (ten thousand vehicles),1), 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.

At this time, data with one decimal place appears in the self-service dataset, as shown in the following figure:

More data examples are as follows:

Formula	Result	Remark
ROUND(2.15,1)	2.2
ROUND(2.149,1)	2.1
ROUND(-1.475,2)	-1.48
ROUND(21.5,-1)	20

Helpful
Not helpful
Only read

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

English

ROUND

1. Overview

2. Matters needing attention

3. Examples

附件列表