List.NonNullCount returning 1 rather than 0

[WayneC]

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 · Accepted solution]

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

[m_dekorte · Accepted solution]

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 · Accepted solution]

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.

[m_dekorte]

@WayneC  It would be awesome if you tagged the response that helped you solve your query as Solution, thanks!