Counting the number of Nulls

[peersbrennanctb]

Hi all

I have a table and I want to count the number of Nulls in the table

How do i do this calculation

Thanks

[N1kh1l]

peersbrennanctb

I am not sure you want to count null for measure or dimension, but you can use the same technique.

IF(ISNULL(["PLANNING":AMOUNT] ) ,1 ,0 )

I am counting the null for my Amount measure. Once you have this measure calculation, you can create restricted measure with constant selection on this measure to get total count of null. Also if you use a parent node , it will give you the total null count.

Br.

Nikhil