老师这段代码哪里有问题,为什么取不到值?
'自动计算已完成金额
Select Case e.DataCol.name
Case "财年","周期"
If e.DataRow("财年") = "2021" And e.DataRow("周期") = "Q1" Then
e.DataRow("已完成") = DataTables("销售报表").SQLCompute("sum(当期收款)","[签单日期] >= '01/04/2020' and [签单日期] <= '31/03/2021' and [分支机构] = '" & e.DataRow("分支机构") & "' and [一级部门] = '" & e.DataRow("二级部门") & "' and [三级部门] = '" & e.DataRow("三级部门") & "'")
End If
End Select