How to count nulls

[ivandrago]

Hi,

I've attached the following Document, I want to count the number nulls in a field and not sure how to do this?

Thanks

[pover]

Would this work for you?

=count(OrderNo) - count({$<PT={"*"}>} OrderNo)

Regards.

[pover · Accepted solution]

Or better, using Tim Benoit's blog for inspiration:

=count({$<OrderNo={"=isnull(PT)"}>} OrderNo)

Regards.

[#4]

I tried this on your example and it seemed to work:

=count(if(isnull(PT),1))

[#5]

nullcount(PT) worked like a charm.

[ivandrago]

Thanks Guy with all your answers!