反馈已提交

网络繁忙

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

INT

  • Recent Updates: April 08, 2022

    • 1. Extract data

    1）Overview

    GrammarINT(number)Returns the nearest integer value after the number is rounded down (the direction in which the value decreases). 
    Parameternumber

    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:

    7.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.

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

    8.png

    More examples are as follows:

    FormulaResultRemark
    INT(4.8)4
    INT(-4.8)-5
    INT(4.3)4
    INT(-4.3+5)0

    2. Real-time data

    1）Overview

    Grammar
    		INT(number)Returns the integer whose number is closest to 0. 
    Parameternumber

    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

    FormulaResultRemark
    INT(4.8)4
    INT(-4.8)-4
    INT(4.3)4
    INT(-4.3+5)0



    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后关闭