• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

chn()

Description:

Write a number with the Chinese numerals.

Syntax:

chn(x)

Note:

The function writes a number x according to the numeral system based on Chinese characters that correspond to numerals in spoken language.

Parameter:

 x If a function doesn’t work with an option or uses @a and @u options, parameter x should be an integer; if it works with @b option, parameter x should be a float

Option:

 @a Write the specific number with the Chinese numeral system in the format of billion, ten thousand, thousand, hundred, ten in order @u Write the specific number with upper case Chinese numerals @b Write the specific number using Chinese characters used for numbers on renminbi banknotes

Example:

 A 1 =chn(97) Result:九七. 2 =chn(-97) Result:负九七. 3 =chn@a(128) Result: 一百二十八. 4 =chn@a(-2594) Result: 负二千五百九十四. 5 =chn@u(128) Result: 壹贰捌. 6 =chn@u(-128) Result: 负壹贰捌. 7 =chn@b(1238.35) Result: 一千二百三十八元三角五分. 8 =chn@ub(100) Result: 壹佰元整.