Skip to main content

Convert numbers to uppercase amounts

1. Usage scenarios​

With this example, let's learn how to use YIDA formula.Convert numbers to uppercase amounts.

2. Implement functions​

2.1 Configuration Table page​

2.2 configuration field Formula​

Modify the component identifier as needed.

(1) amount to uppercase (including angular points)​

{"text":"RMBFORMAT(​金额​)","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":14,"sticky":null},"value":"numberField_ksr4oq3u","invalid":false}],"isCmData":true}

(2) amount to uppercase (excluding angular points)​

{"text":"RMBFORMAT(INT(​金额​))","marks":[{"from":{"line":0,"ch":14,"sticky":null},"to":{"line":0,"ch":18,"sticky":null},"value":"numberField_ksr9w5k7","invalid":false}],"isCmData":true}

3. Achieve results​

4. Try it online​

This doc is generated using machine translation. Any discrepancies or differences created in the translation are not binding and have no legal effect for compliance or enforcement purposes.
© 2014–2025 DingTalk Technology Co., Ltd