3 Replies Latest reply: Jun 10, 2013 4:22 AM by Kumar Natarajan RSS

    RowNo() in Background Color in Expression causes zero values to appear?

    Dominic Ayling

      Hi All


      My requirement was to alternately strip rows but only for specific columns in a straight table, so I can delineate particular columns from others but retain the stripe effect.


      I used the expression:


      =If(Even(RowNo(TOTAL)), rgb(220,220,220), rgb(238,233,233))


      This works sort of but with the problem that all values including zero values now show for that expression even though I have suppress zero values ticked?


      Can anyone advise why and how I might fix this?