Counting NULL values

[#1]

Hi all,

I am looking to count LOCATION = London where L_ID is Null

LOCATION                                         L_ID

London                                                 -

North London                                      1214

London                                               2485

London                                                 -

London                                               4789   

NW London                                           -

The expression I had written doesnt seem to work:

Count(IF(LEN(L_ID < 0) , LOCATION = 'LONDON')) 

Thanks.

Koushik.

[alexandros17]

try this

Count(IF(isnull(L_ID) , LOCATION = 'LONDON')) 

[#3]

Nope, doesnt work.

In the above table if you see the null values are 3 therfore the Loctaion = 'LONDON' cannot exceed 3 but I get more than 3 values.

[Gysbert_Wassenaar · Accepted solution]

try:

count({<Location={'London'},L_ID-={'*'}>} Location)

[#5]

Thanks Gysbert Wassennar