Calculate percentage by formula

1. Usage scenarios

In this example, let's learn how to calculate the percentage based on the corresponding input result through the YIDA formula.

2. Implement functions

2.1 Configuration Table page

2.2 configuration field Formula

Modify the fields as needed.

Attendance rate =Actual attendance/total number.

{"text":"TEXT(​实际出勤人数​/​总人数​,\"##.##%\")","marks":[{"from":{"line":0,"ch":5,"sticky":null},"to":{"line":0,"ch":13,"sticky":null},"value":"numberField_ksi9hif0","invalid":false},{"from":{"line":0,"ch":14,"sticky":null},"to":{"line":0,"ch":19,"sticky":null},"value":"numberField_ksi9hif1","invalid":false}],"isCmData":true}

3. Achieve results

4. Try it online

示例中心 | 开发者赋能平台

AI智能体时代，全新宜搭。业务创新，一搭就行。

https://www.aliwork.com/o/coc?tplUuid=TPL_OU7LL38TJEEBRQZ6S9EH&from=yuque_subject