cancel
Showing results for 
Search instead for 
Did you mean: 

Counting the number of Nulls

peersbrennanctb
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

N1kh1l
Active Contributor
0 Kudos

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

peersbrennanctb
Explorer
0 Kudos

nikhil_1486 do you have any idea?