Null Values

[kalyandg]

Hi

I have a issue for null values, my client needs to display null values as red color in pivot table through the visual cues,

I think we can do it by unchecking a supress zero values, in the presentation tab, but i dont want to do like this,

is there any expr to be used in visual cues, as if null value show in red color?

please help me to solve this prob.

Thanks,

Kalyan

[khadeer]

Hi

if(Expression= null(),RGB(255,0,0)

regards,

Khadeer

[kalyandg]

hi Khadeer,

Thanks, it works

[kalyandg]

hi

its not working

[hic · Accepted solution]

No, comparing with NULL never works. It will always show false.

Use IsNull(Expression) instead. Or Len(Trim(Expression))=0.

HIC

[kalyandg]

hi Henric,

Thank you for help.

I need to set red color for null values displaying in pivot table, your expression is working, but in the visual cues tab we set some range for green and red. i had set green for all the values displaying and till i need to set red for null values.

how can i do that.......... please help me to solve.