红色的部分计数出错,怎么改?sz2(0)是用于目录的列名称,比如是用 “当事人列” 作为目录列,sz2(0)就是“当事人”
If sz(4) = "" Then 当第五个数组为空时
nd.Text = nd.text & "(" & dt.Compute("Count(" & "[" & sz2(0) & "]" & ")","[" & xt & "] = '" & ly & "'") & ")" '当要统计的列为空时就统计行数
nd.Text = nd.text & "(" & dt.Compute("Count("["
& sz2(0) & "]")","[" & xt & "] = '" & ly
& "'") & ")"
Else
nd.Text = nd.text & "(" & dt.Compute("sum(" & sz(4) & ")","[" & xt & "] = '" & ly & "'") & ")" '等于节点名称,这个没有问题
End If
[此贴子已经被作者于2021/4/22 10:28:38编辑过]