SSRS在具有加权平均值的总数上的除以零误差

Question

当试图获得总加权平均利率时，当某些列中只有一项时，我偶尔会收到错误。Iif语句处理此问题时遇到问题：

=Iif(Sum(Fields!Current_Principal_Balance.Value) = 0, 0, SUM(Fields!Current_Principal_Balance.Value * Fields!WAIR.Value))/Iif(Sum(Fields!Current_Principal_Balance.Value) = 0, 1, SUM(Fields!Current_Principal_Balance.Value))

Answer 1

稍微移动一下括号，这似乎有效：

=Iif(Sum(Fields!Current_Principal_Balance.Value) = 0, 0, 
SUM(Fields!Current_Principal_Balance.Value * Fields!WAIR.Value)/Iif(Sum(Fields!Current_Principal_Balance.Value) = 0, 1, SUM(Fields!Current_Principal_Balance.Value)))