式によるサブフォームデータの加重平均の計算

1. 使用シーン

この例では、サブフォームの条件を満たすデータの加重平均を式で計算する方法を学びます。

2. 機能を実現する

2.1. 設定ページ

選択するかどうか: ラジオコンポーネント

量: 数値コンポーネント

価格: 数値コンポーネント (小数点以下の桁数:2)

測定原価和: 数値コンポーネント (小数点以下の桁数:2)

量と: 数値コンポーネント

平均価格: 数値コンポーネント (小数点以下の桁数:2)

2.2. フィールド式の設定

原価和 (計算条件: 選択するかどうか = はい):

{"text":"SUM(IF(EQ(​子表单.是否选中​,\"是\"),​子表单.量​*​子表单.价​,0))","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"radioField_lw5pla9v","invalid":false},{"from":{"line":0,"ch":26,"sticky":null},"to":{"line":0,"ch":33,"sticky":null},"value":"numberField_lw5pla9w","invalid":false},{"from":{"line":0,"ch":34,"sticky":null},"to":{"line":0,"ch":41,"sticky":null},"value":"numberField_lw5pla9x","invalid":false}],"isCmData":true}

量と (計算条件: 選択するかどうか = はい):

{"text":"SUM(IF(EQ(​子表单.是否选中​,\"是\"),​子表单.量​,0))","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"radioField_lw5pla9v","invalid":false},{"from":{"line":0,"ch":26,"sticky":null},"to":{"line":0,"ch":33,"sticky":null},"value":"numberField_lw5pla9w","invalid":false}],"isCmData":true}

平均価格 (計算条件: 選択するかどうか = はい):

{"text":"SUM(IF(EQ(​子表单.是否选中​,\"是\"),​子表单.量​*​子表单.价​,0))/SUM(IF(EQ(​子表单.是否选中​,\"是\"),​子表单.量​,0))","marks":[{"from":{"line":0,"ch":10,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"radioField_lw5pla9v","invalid":false},{"from":{"line":0,"ch":26,"sticky":null},"to":{"line":0,"ch":33,"sticky":null},"value":"numberField_lw5pla9w","invalid":false},{"from":{"line":0,"ch":34,"sticky":null},"to":{"line":0,"ch":41,"sticky":null},"value":"numberField_lw5pla9x","invalid":false},{"from":{"line":0,"ch":56,"sticky":null},"to":{"line":0,"ch":66,"sticky":null},"value":"radioField_lw5pla9v","invalid":false},{"from":{"line":0,"ch":72,"sticky":null},"to":{"line":0,"ch":79,"sticky":null},"value":"numberField_lw5pla9w","invalid":false}],"isCmData":true}