ncye ncsl ncdj
原理是ncdj=ncye/ncsl
但有时ncsl为0,所以不能除
我想实现当ncsl为0时,ncsl为0,当ncsl不为能零时ncdj=ncye/ncsl
所在在ncdj的公式中为
(case when ([ncsl]) = 0) then 0 else (([ncye]/([ncsl])) end)哪错了
原理是ncdj=ncye/ncsl
但有时ncsl为0,所以不能除
我想实现当ncsl为0时,ncsl为0,当ncsl不为能零时ncdj=ncye/ncsl
所在在ncdj的公式中为
(case when ([ncsl]) = 0) then 0 else (([ncye]/([ncsl])) end)哪错了
case when [ncsl] = 0 then 0 else [ncye]/[ncsl] end
case when cast(([ncsl] = 0) as decimal(1,3)) then 0 else cast([ncye] as float)/[ncsl] end