6,108
社区成员
发帖
与我相关
我的任务
分享Reporting Services 2008 报表开发 表达式除0错误
=IIf(SUM(Fields!PreAll.Value)<1,1,SUM(Fields!CurAll.Value)/SUM(Fields!PreAll.Value))
或
=IIf(SUM(Fields!PreAll.Value)=0,1,SUM(Fields!CurAll.Value)/SUM(Fields!PreAll.Value))
已经对分母做过判断,还是一直报除0错误
或
=IIf(SUM(Fields!PreAll.Value)=0,1,SUM(Fields!CurAll.Value)/SUM(Fields!PreAll.Value))
已经对分母做过判断,还是一直报除0错误
...全文
请发表友善的回复…
发表回复
sdwbcvbrtcwwww 2011-09-09
- 打赏
- 举报
楼上说的对
HoneyYan 2011-08-26
- 打赏
- 举报
IIF会首先判断各参数的值,上式第三个参数SUM(Fields!CurAll.Value)/SUM(Fields!PreAll.Value)就会遇到除以0错误.改为:
=SUM(Fields!CurAll.Value)/IIf(SUM(Fields!PreAll.Value)=0,1,SUM(Fields!PreAll.Value))
=SUM(Fields!CurAll.Value)/IIf(SUM(Fields!PreAll.Value)=0,1,SUM(Fields!PreAll.Value))
