Hi all,
I need to count the number of nulls from a particular column, what kind of formula should be used in that case?
May be I am looking for an equivalence of COUNTIF from Excel,
Thank you!
7 answers
hi Tenzin,
Something like
SUM(IIF(ISNULL([YourField]),1,0))
should do the trick.
Let me know if it doesn't, or that doesn't make sense
