反馈已提交

网络繁忙

NUMTO - Returning Number-Converted Chinese Texts

  • Last update：  2023-07-25

    • Overview

    Grammar

    NUMTO (number, bool) or NUMTO (number)

    Returns number-converted Chinese texts.

    Parameter 1

    number

    Number

    Parameter 2

    boolean

    Determines how to display the Chinese text. If the NUMTO function contains no boolean value, the result is displayed in a default way.

    The default boolean value is false.

    Notes

    • The function supports two parameters. The first parameter is of the numeric type and the second is of the boolean type.

    • The "true (TRUE)" and "false (FALSE)" in the second parameter are case-insensitive.

    • iconNote:
      Direct connect data does not support the NUMTO function.

    Example

    If you want to convert the "Advertising fee" to Chinese text, such as converting "120000" to "十二万", you can enter the formula NUMTO(Advertising fee), as shown in the following figure.

    NUMTO.png

    More examples:

    FormulaResultNotes
    NUMTO(2345,true)二三四五
    NUMTO(2345,false)二千三百四十五
    NUMTO(2345)二千三百四十五



    Attachment List


    Theme： Advanced Data Analyis
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ
    中文（简体） 中文（繁體） English
    日本語

    フィードバック

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

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

    不再提示

    10s后关闭