Null Count

[bhavvibudagam]

Hi Experts,

I am trying to calculate the Null values present in Value field. Here the nullcount under Value is 17.

Please provide the solution to calculate the Nullcount under value field apart from below two methods.

=Count( IF(ISNULL(Value) OR LEN(trim(Value))=0 OR Value=0,1))

=NullCount(Value)

ID	Value
1	-1301
2
3
4	7
5
6	63
7
8	77
9
10
11
12
13
14
15
16	71
17
18
19
20	32
21
22	45
23
24	38
25
26	41

Thanks in advance

[vishsaggi · Accepted solution]

May use a NullAsValue and count on that Field. Like

NULLASVALUE Value;

SET NullValue = '<NoData>';

YourLoadStatement. Like

LOAD ID, Value

FROM yoursource;

Then use like

= Count({< Value = {'<NoData>'} >} ID )

[zebhashmi]

ITHINK

Count(aggr({<Value={0}>}ID))

[bhavvibudagam]

Hi,

The expression is showing error.

Thanks,

[devarasu07]

Hi,

is there any issue using below set analysis method to calculate null count? would be able to share the expected output.

=Count({<ID = {"=Len(trim(Value))=0"}>} Value)

[bhavvibudagam]

=Count({<ID = {"=Len(trim(Value))=0"}>} ID) Its working when we use Value then getting 0 as output.

I got the expected output. I am looking for different Methods for NullCount calculation.

Thanks every one for providing all the Different Approaches for the Null Count Calculation.