Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i want to check in each filed null count how can i check this?
is there any specific method ?
Thanks
Sony
which kind of file are you referring. Please provide sample.
Hi Sony,
You can use =NullCount( <FieldName> ) to count null values for a specific field.
Use :
NullCount(field name)
its not working tried
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>))
Show us some sample data please. Also you can try below:
Len(Trim(Field1))=0
Use Both
=NullCount(Tot) + Count(If(Len(Trim(Tot))=0,Tot))
So that it will count null and spaces both.
Try set analysis with -=
Count({<Column_Name-={"*"}>} Column_Name)
thanks all its working this
=Count(distinct If(Len(Trim(Type))=0,Type))