反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

ROUND

  • Recent Updates: April 08, 2022

    • 1. Overview

    GrammarROUND(number,num_digits)Returns a number rounded by a specified number of digits.
    Parameter1number

    The number to be rounded.

    Parameter2num_digitsRounding 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:

    5.png

    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:

    6.png

    More data examples are as follows:

    FormulaResultRemark
    ROUND(2.15,1)2.2
    ROUND(2.149,1)2.1
    ROUND(-1.475,2) -1.48
    ROUND(21.5,-1) 20


    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭