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

[#1]

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?

Thanks

Dominic

[#2]

Please can anyone help?

Thanks

[Gysbert_Wassenaar]

You can enable striping on the Style tab and custom format the cell background colors. Or you can use a calculated dimension. See attached example.

For the custom formatting you need to enable the option Always Show Design Menu Items on the Design tab of the user properties window. With this enabled you can right click a cell and choose Custom Format Cell.

[kumarnatarajan]

Hi,

You can able to use this condition in dimention field bg area. see the below screenshort

else.

Use Gysbert Wassenaar  way.