RE:Null display

[Chanty4u]

Hi all,

I have a issue .

i have one filter like

Year

2000

2001

2002   lik dat ..... and i have a bar chart .   so my requirment is :

in that years i have  some null values.     so when i ever i clik on any year  for that year null values should display on chart?

how can i do this?

Thanks in advance

Best

Chanty

[swuehl · Accepted solution]

NULL is not a value, so I am not sure what you want to show in your chart.

Maybe the count of records with NULL?

=NullCount(Field)

[sunny_talwar]

How can you display null values? You mean to display the count of Null value?

May be Year as dimension and NullCount(Value) as Expression?

[Chanty4u]

yes sunny....

but  if i want show in Pivot or stright table ? how can i do this?

[sunny_talwar]

The same way as Stefan and I mentioned. Add an expression NullCount(Value) with year as your dimension and all other dimensions you may have

[Chanty4u]

thnku stefan and sunny