Forum Discussion
Solved
Counting nulls
Hi, counting null values, i have; = let alist =
{1,2,2,"a",null, null, 2,"a",3,2,null, "a"}
in
List.Count( alist) - List.NonNullCount( alist)
or
= let alist =
{1,2,2,"a",nul...
Hi Dicken,
For pure null values, I would keep your first approach. It is probably the cleanest and easiest to read:
let alist = {1,2,2,"a",null, null, 2,"a",3,2,null, "a"} in List.Count(alist) - List.NonNullCount(alist)List.NonNullCount is built to count non-null items, so total count minus non-null count gives the null count.
List.Accumulate(alist, 0, (i,x) => i + Number.From(x=null))
List.Sum(List.Transform( alist, each Number.From(_=null)))
let
fx = (x, y) => if List.Count(x) = 0 then y else @ fx(List.Skip(x), y + Number.From(x{0} = null))
in
fx({1, 2, 2, "a", null, null, 2, "a", 3, 2, null, "a"}, 0)