User1984700640 posted
I presently have this code which fixes my "Infinity" problem:
=IIF((Count(Fields!bk_id.Value) -
Sum(Fields!ExitSale.Value))/
(Count(Fields!it_id.Value) - Count(Fields!tour_date.Value) - Count(Fields!it_cancel_date.Value)) = "Infinity", 0,
(Count(Fields!bk_id.Value) -
Sum(Fields!ExitSale.Value))/
(Count(Fields!it_id.Value) - Count(Fields!tour_date.Value) - Count(Fields!it_cancel_date.Value)))
But sometimes I also get NaN as my result. How can I change the above code to display 0 instead of NaN but still keep my "Infinity" situation working?