Count for Null

[k_burata]

Hi I have been trying to count rows which looks at when a column is not null but seem to be getting no where.

Here's my data:

So I'm trying to count rows which has no Payment Ticked of Amount. It works well when I count those that have value more than 0.

     "=Count({<[Payment Ticked of Amount] = {"*"}>} [Payment Ticked of Amount])" gives me 2

But "=Count({<[Payment Ticked of Amount] -= {"*"}>} [Payment Ticked of Amount])" gives me 0. Should be 3.

TIA.

[fabdulazeez]

you are trying to count null values

Try

"=Count({<[Payment Ticked of Amount] -= {"*"}>} [Payment Series ID])"

[tamilarasu]

Hi Kim,

=Count({<[Payment Series ID] = {"=Len(Trim([Payment Ticket of Amount]))=0"}>} [Payment Series ID])

[jonathandienst · Accepted solution]

Count only counts non-null values. Therefore there is a NullCount() function:

=NullCount([Payment Ticked of Amount])

[Digvijay_Singh]

May be try this -

NullCount([Payment Ticked of Amount] )

[k_burata]

This worked for me.

Cheers!