Forum Discussion
Solved
AggregateTableColumn with List.Count returns 1 instead of 0
With an aggregation I get an unexpected result. The 'parent' table is as follows: ROUTING_ID 1 2 3 The 'child' table is as follows: ROUTING_ID_From ROUTING_ID_To 1 23 ...
I've found the solution: instead of List.Count must be used List.NonNullCount.
I can confirm that the solution works, but could anybody explain why?! AggregateTableColumn returns empty tables which return empty lists for columns and List.Count of an empty list is 0, after all!