Alternate row color +null

[nareshthavidishetty]

Hi ,

I have used the below logic to get the alternate colors.But i'm not get the colored null values.

Logic: =if(even(RowNo(TOTAL)),lightgray(),white())

Thanks..

[dsharmaqv]

try this

Coloring alternate rows in a straight table

[marcus_sommer]

AFAIK NULL couldn't be colored - therefore you need to replace the NULL's with a real value either within the data or maybe by something like: rangesum(YourExpression, 0) as chart-expression.

- Marcus

[avinashelite]

Try this

=if(even(RowNo(TOTAL)),lightgray(),if(even(RowNo(TOTAL)) and expression=null(),lightgray(),white()))

[nareshthavidishetty]

Hi,

It's not working.

Thanks..

[sasikanth]

Try this

IF(Even(RowNo(TOTAL)) OR Len(Even(RowNo(TOTAL)) )=0,Lightgray(),white())

[avinashelite]

Then convert the null values to 0 ,

if(len(Trim(Expression))>0,Expression,0)

NOTE:

Replace the Expression with your actual expression

[avinashelite]

if you are not able to achieve the same, provide the sample app

[nareshthavidishetty]

Hi,

Still the nulls were not colored.

Thanks..

[Anil_Babu_Samineni]

Would you provide sample to look, Where this is not working. Even i've dump and i tried it covered to Null values