Forum Discussion
Report Builder - Need IFERROR Equivalent
Using MS Report Builder, I have a calculated field in the report where part of the equation is rendering a 0 and as a result the whole calculation is getting set to 0. However, I want to include an ...
I've also tried using the following calculation but it's not working either:
=IIf(IsNothing(Sum(Fields!PrevBal_x_PrevFtpRate_Step1_3.Value)/Sum(Fields!PrevBook_Step1_3.Value))=0,0,Sum(Fields!PrevBal_x_PrevFtpRate_Step1_3.Value)/Sum(Fields!PrevBook_Step1_3.Value))-IIf(IsNothing(Sum(Fields!PrevBal_x_PrevFtpRate_Step1_2.Value)/Sum(Fields!PrevBook_Step1_2.Value))=0,0,Sum(Fields!PrevBal_x_PrevFtpRate_Step1_2.Value)/Sum(Fields!PrevBook_Step1_2.Value))