[求助]交叉统计后,手工增加列无法求值(如果有空值被求和,直接为空,求不出) - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

如题: x1,x2,y1,y2 如果有一个空值,那么分母出来的值就是空值. 如何解决.

代码如下:

Dim x1 As String

Dim x2 As String

Dim x7 As String

Dim y1 As String

Dim y2 As String

Dim r1 As DataRow

For Each dc As DataCol In tab.DataTable.DataCols

If dc.Caption.Contains("磷酸") AndAlso dc.Caption.Contains("广东") Then

x1 = dc.Name

ElseIf dc.Caption.Contains("硫酸") AndAlso dc.Caption.Contains("广东") Then

x2 = dc.Name

ElseIf dc.Caption.Contains("磷酸") AndAlso dc.Caption.Contains("上海") Then

y1 = dc.Name

ElseIf dc.Caption.Contains("硫酸") AndAlso dc.Caption.Contains("上海") Then

y2 = dc.Name

ElseIf dc.Caption.Contains("铝材") Then

x7 = dc.Name

End If

'上面是交叉统计后得到的表,下面是手工增加的列.

tab.DataTable.DataCols.Add("工厂_铝比磷硫",Gettype(Double),"" & x7 & "/(" & x1 & "+" & x2 & "+" & y1 & "+" & y2 & ")")

主题：[求助]交叉统计后,手工增加列无法求值(如果有空值被求和,直接为空,求不出)