公式で最高点の最低点を除いて平均点を計算する

1. 使用シーン

この例を利用して、私たちはどのように適切な公式を通過するかを学びます最高点最低点を除いて平均点を計算する。

2.機能を実現する

2.1構成表ページ

この例では、5人の審査員の状況をシミュレーションします。

2.2フィールド式の設定

実際のニーズに基づいてコンポーネントidを変更することに注意してください。

(1)最大値

{"text":"MAX(ARRAYGET(​评分详情.评分​,1),ARRAYGET(​评分详情.评分​,2),ARRAYGET(​评分详情.评分​,3),ARRAYGET(​评分详情.评分​,4),ARRAYGET(​评分详情.评分​,5))","marks":[{"from":{"line":0,"ch":13,"sticky":null},"to":{"line":0,"ch":22,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":35,"sticky":null},"to":{"line":0,"ch":44,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":57,"sticky":null},"to":{"line":0,"ch":66,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":79,"sticky":null},"to":{"line":0,"ch":88,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":101,"sticky":null},"to":{"line":0,"ch":110,"sticky":null},"value":"numberField_lc0bws59","invalid":false}],"isCmData":true}

(2)最小値

{"text":"MIN(ARRAYGET(​评分详情.评分​,1),ARRAYGET(​评分详情.评分​,2),ARRAYGET(​评分详情.评分​,3),ARRAYGET(​评分详情.评分​,4),ARRAYGET(​评分详情.评分​,5))","marks":[{"from":{"line":0,"ch":13,"sticky":null},"to":{"line":0,"ch":22,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":35,"sticky":null},"to":{"line":0,"ch":44,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":57,"sticky":null},"to":{"line":0,"ch":66,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":79,"sticky":null},"to":{"line":0,"ch":88,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":101,"sticky":null},"to":{"line":0,"ch":110,"sticky":null},"value":"numberField_lc0bws59","invalid":false}],"isCmData":true}

(3)平均点

{"text":"(SUM(​评分详情.评分​)-​最大值​-​最小值​)/3","marks":[{"from":{"line":0,"ch":5,"sticky":null},"to":{"line":0,"ch":14,"sticky":null},"value":"numberField_lc0bws59","invalid":false},{"from":{"line":0,"ch":16,"sticky":null},"to":{"line":0,"ch":21,"sticky":null},"value":"numberField_lc0bws5c","invalid":false},{"from":{"line":0,"ch":22,"sticky":null},"to":{"line":0,"ch":27,"sticky":null},"value":"numberField_lc0bws5h","invalid":false}],"isCmData":true}