Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
No, comparing with NULL never works. It will always show false.
Use IsNull(Expression) instead. Or Len(Trim(Expression))=0.
HIC
Hi
if(Expression= null(),RGB(255,0,0)
regards,
Khadeer
hi Khadeer,
Thanks, it works
hi
its not working
No, comparing with NULL never works. It will always show false.
Use IsNull(Expression) instead. Or Len(Trim(Expression))=0.
HIC
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.