我在报告中使用下面的表达式
=IIF((Sum(Fields!Starts.Value)-Sum(Fields!Withdrawn.Value))=0, Nothing,
(Sum(Fields!Starts.Value)-Sum(Fields!Withdrawn.Value))/(Max(Fields!Year1Starts.Value)))
当我运行报告时,我收到以下消息,并显示为#Error
Warning 1 [rsRuntimeErrorInExpression]
The Value expression for the textrun ‘Textbox110.Paragraphs[0].TextRuns[0]’ contains an error:
Attempted to divide by zero.
我尝试了这个,但是得到了同样的错误:
=IIF((Sum(Fields!Starts.Value) - Sum(Fields!Withdrawn.Value)) = 0, Nothing,
(Sum(Fields!Starts.Value) - Sum(Fields!Withdrawn.Value))/
IIF(Max(Fields!Year1Starts.Value)=0,1,Max(Fields!Year1Starts.Value)))
有人可以帮忙吗?
阿鲁那
我尝试了这个,它的工作原理:
=IIF(Max(Fields!Year1Starts.Value)=0,0,(Sum(Fields!Starts.Value)
- Sum(Fields!Withdrawn.Value))/IIF(Max(Fields!Year1Starts.Value)=0,1,
Max(Fields!Year1Starts.Value)))
我遵循了这一点:
=IIF ( Denominator = 0, Nothing, Numerator / IIF( Denominator = 0, 1, Denominator) )
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句