sql - Exclude a row from a table which is not useful in SSRS -

thes table shows me rows not useful. nan value used expression here exclude it:

   iif(fields!goodunits.value=0 or fields!theoreticalunits.value=0,            0, (fields!unit.value / fields!sum.value) 

now shows me 0 values. exclude thes row not useful in table.

since it's issue query, here's suggestion without knowing data. wrap entire query inside inline view, , make clause eliminate 0.0 rows. such as:

select * (select theoreticalunits, ipaddress your-tables) main main.theoreticalunits <> 0.0