通过数量和单价自动计算金额的问题

[清心棕榈]

我在一个DW中放置了订单数量、单价和金额的列，想在订单数量或单价数据改变后，自动计算金额，我在这个DW中，写入以下代码，但运行后，刚在单价中输入数据就报错，这个可以怎么改？

[sdhp]

估计是数量=null引起的吧 if columnname='dingdanshuliang' or columnname='danjia' then decimal shuliang,danjia if columnname='dingdanshuliang' then shuliang=dec(data) danjia=dw_2.Object.danjia[rowNum] if isnull(danjia)then danjia=0 else shuliang=dw_2.Object.dingdanshuliang[rowNum] if isnull(shuliang) then shuliang=0 danjia=dec(data) end if dw_2.object.jine[rowNum]=shuliang*danjia end if

[zhangyangziwo]

你的单价是文本类型的缘故

[清心棕榈]

if columnname='dingdanshuliang' or columnname='danjia' then decimal shuliang,danjia if columnname='dingdanshuliang' then shuliang=dec(data) danjia=dec(dw_2.getitemnumber(rowNum,"danjia")) else shuliang=dec(dw_2.getitemnumber(rowNum,"dingdanshuliang")) danjia=dec(data) end if dw_2.object.jine[rowNum]=shuliang*danjia end if

[清心棕榈]

那我就来试一下getitemstring试试看。