dr("平均分") = dt.Compute("Avg(" & dr("科目") & ")", filter)
dr("及格人数") = dt.Compute("Count(姓名)", dr("科目") & " >= 60 and " & filter)
dr("不及格人数") = dt.Compute("Count(姓名)", dr("科目") & " < 60 and " & filter)
dr("考试人数") = dt.Compute("Count(姓名)", dr("科目") & " >= 0 and " & filter)
dr("优秀率") = dt.Compute("Count(姓名)", dr("科目") & " >= 85") / dt.Compute("Count(姓名)")
dr("及格率") = dt.Compute("Count(姓名)", dr("科目") & " >= 60") / dt.Compute("Count(姓名)")
问题:如何根据上面的写均分值的代码?
均分值=均分乘以70%+及格率乘以20+优秀率乘以10