Set Analysis - Counting Null Values

[eduardo_dimperio]

Hi,

I need to count how many  meters I have when my field CONSUMO_MADRUGADA is null.

I tried:

Count({<CONSUMO_MADRUGADA-={"''"}>} DISTINCT OID_METER )

Count( {<CONSUMO_MADRUGADA={"=Len(CONSUMO_MADRUGADA)=0 "}>}DISTINCT OID_METER)

Count({<CONSUMO_MADRUGADA=-{}>} DISTINCT OID_METER)

with no sucess.

Any idea?

[Kushal_Chawda · Accepted solution]

try below

Count({1-$<CONSUMO_MADRUGADA={"*"}>} DISTINCT OID_METER )

[eduardo_dimperio]

Hi Kush, that works  for me.

Could you please explain this line code?

I don't know if  I understand, first you select every  CONSUMO_MADRUGADA that's not null ( $<CONSUMO_MADRUGADA={"*"}>) and then subtract of the total? 

[Almen]

Try this:

IF(IsNull(CONSUMO_MADRUGADA)=-1 , Count(DISTINCT OID_METER))

[Kushal_Chawda]

@eduardo_dimperio  CONSUMO_MADRUGADA={"*"} will help to find first all the instances of  CONSUMO_MADRUGADA which are not null.  Then set identifier 1-$ help to find the null values by subtracting not null values from entire data set