Qlikview Pivot table Alternating row colors

[olivetwist]

We currently have a pivot table with 3 dimensions that has alternating colors on rows. the issue is that when using a formula in the "Background Color" section of each dimension and expression causes the pivot table to show rows that have zeros for the value even when "Suppress Zero-Values" is checked. 

Does anyone know how to show a pivot table with alternating color rows that still hides rows with Nulls AND zeros?

[sergio0592]

What is your formula in Background color, I suppose, you're using even() function.

[olivetwist]

Yes, we are using "even()". I have also tried "

if(SubStringCount(RowNo()/2,'.')=0 AND RowNo() <> 0,lightgray(),white())