如何在DW中使MSSQL的空值字段参加计算得出正确计算列

[scan30]

SELECT goods.dl, SUM(xs.sl * goods.lsj) AS xs, SUM(dc.sl * goods.lsj) AS dc,
SUM(dr.sl * goods.lsj) AS dr, SUM(zs.sl * goods.lsj) AS zs, SUM(zsth.sl * goods.lsj)
AS th, SUM(goods.kc * goods.lsj) AS kc，SUM(goods.kc * goods.lsj) +SUM(dr.sl * goods.lsj)+SUM(zs.sl * goods.lsj)-SUM(xs.sl * goods.lsj)-SUM(dc.sl * goods.lsj)-SUM(zsth.sl * goods.lsj) AS qmkc
FROM dc RIGHT OUTER JOIN
goods ON dc.spbh = goods.spbh LEFT OUTER JOIN
dr ON goods.spbh = dr.spbh LEFT OUTER JOIN
xs ON goods.spbh = xs.spbh LEFT OUTER JOIN
zs ON goods.spbh = zs.spbh LEFT OUTER JOIN
zsth ON goods.spbh = zsth.spbh
GROUP BY goods.dl

如果其中一个计算列字段为空，如何使最后一个汇总计算列字段得出正确计算值

[sunxiaobo]

if(isnull(column_name),0,column_name)

[kingdomzhf]

sum(not isnull(aa))

[Thinkinger]

对可以为null的数据列，要参加计算的！最好用isnull(columnname,0)约束以下，它的意思是如果为null的话，就默认为0

[JIANXIN_LU]

IsNull( columnaname, 0 )

[liaolwj]

如果你是在SQL语句中进行处理，那就加个条件where colname is not null

[tchatcha]

if(isnull(column_name),0,column_name)

[andyzq]

在数据库表中为允许为null的字段设置默认值0,如果已经有数据为null,则使用case语句
进行处理，或者在datawindow中处理