Forum Discussion

WayneC's avatar
WayneC
Regular Visitor
3 years ago
Solved

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:   fo...
Need Help
  • m_dekorte's avatar
    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's avatar
    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.

m_dekorte's avatar
m_dekorte
Resident Rockstar
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's avatar
WayneC
Regular Visitor
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.

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    3 years ago

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