List.NonNullCount returning 1 rather than 0

Is there any reason why this would return an answer of 1 when all columns counted are null ?

example: (foreman.1.2 is column 8 when referencing the formula below):

results:

formula:

"Count_Foreman", each List.NonNullCount(List.Range(Record.FieldValues(_),8,4)))

This returns the correct number for all "NonNull" counts, but when all four columns are null, it returns "1" every time.

m_dekorte
3 years ago
Hi WayneC,

Break out the List.Range part and validate what it returns.
For example this code below returns: { 7, 8 }

List.Range( {1..10}, 6, 2 )

I hope this is helpful
WayneC
3 years ago
Thanks.. Goes back to simple de-bugging by command. Turns out first column is ref = 0, so the column ref in my formula should be 7,4 not 8,4... thank you.

Forum Discussion