Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Or better, using Tim Benoit's blog for inspiration:
=count({$<OrderNo={"=isnull(PT)"}>} OrderNo)
Regards.
Would this work for you?
=count(OrderNo) - count({$<PT={"*"}>} OrderNo)
Regards.
Or better, using Tim Benoit's blog for inspiration:
=count({$<OrderNo={"=isnull(PT)"}>} OrderNo)
Regards.
I tried this on your example and it seemed to work:
=count(if(isnull(PT),1))
nullcount(PT) worked like a charm.
Thanks Guy with all your answers!