where '0' NOT IN (I_DET_FACTOR1, I_DET_PERC1, I_DET_FACTOR2, I_DET_PERC2, I_DET_FACTOR3, I_DET_PERC3)
To hide row when any column is zero (show row when all columns are not zero)
WHERE
I_DET_FACTOR1 <> '0'
AND I_DET_PERC1 <> '0'
AND I_DET_FACTOR2 <> '0'
AND I_DET_PERC2 <> '0'
AND I_DET_FACTOR3 <> '0'
AND I_DET_PERC3 <> '0'
To hide row when all columns are zero (show row when any column is not zero)
WHERE
I_DET_FACTOR1 <> '0'
OR I_DET_PERC1 <> '0'
OR I_DET_FACTOR2 <> '0'
OR I_DET_PERC2 <> '0'
OR I_DET_FACTOR3 <> '0'
OR I_DET_PERC3 <> '0'