在 SSRS 表达式中除以零错误

Question

我在报告中使用的表达式如下

            =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)))

有人可以帮忙吗？

阿鲁纳

Answer 1

我试过这个，它有效：

    =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) )

Answer 2

你必须处理除数并防止它获得 0 作为值。像这样：

=IIf(Fields!SomeField.Value = 0, 0, Fields!SomeOtherField.Value / IIf(Fields!SomeField.Value = 0, 1, Fields!SomeField.Value))

这将在除数中将 0 替换为 1，从而避免此错误。