I am wondering how to handle #ERROR, NAN and INFINITY in a single expression of SSRS reprot when my formula is (A/B)-1). I have used the following expression to handle NAN and INFINITY which worked perferctly fine.
=iif ( ( ((A/B)=0) OR B=0 ), 0, (A/B)-1) )
( Says that if A/B=0 or B=0 then display 0 else display (A/B)-1=0 )
With this code I am getting #ERROR in my report when it divides 0/0 as the value of a and b is zero. My problem is to handle # ERROR also in this expression. Please help.