Null count

[soniasweety]

Hi All,

i want to check  in each filed null count  how can i check this?

is there any specific method ?

Thanks

Sony

[suhaskharat]

which kind of file are you referring. Please provide sample.

[ggijben]

Hi Sony,

You can use =NullCount( <FieldName> ) to count null values for a specific field.

[arvind1494]

Use :

NullCount(field name)

[soniasweety]

its not working tried 

[ggijben]

Are you sure that there are real NULL values instead of " "? An empty value is still a value, which is different from NULL.

Can you try this:

Count(If(Len(Trim(<FIELD>))=0,<FIELD>))

[trdandamudi]

Show us some sample data please. Also you can try below:

Len(Trim(Field1))=0

[suhaskharat]

Use Both

=NullCount(Tot) + Count(If(Len(Trim(Tot))=0,Tot))

So that it will count null and spaces both.

[sibin_jacob]

Try set analysis with -=

Count({<Column_Name-={"*"}>} Column_Name)

[soniasweety]

thanks all its working this

=Count(distinct If(Len(Trim(Type))=0,Type))