Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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 ...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Maybe you can try this:

     

    =IIf(IsNothing(Sum(Fields!PrevBook_Step1_3.Value)) Or 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!PrevBook_Step1_2.Value)) Or Sum(Fields!PrevBook_Step1_2.Value) = 0, 0, Sum(Fields!PrevBal_x_PrevFtpRate_Step1_2.Value)/Sum(Fields!PrevBook_Step1_2.Value))

     

    Best Regards,
    Jing