How to handle EMPTY value in 'intersect with' advanced filter

Sure, but @amjad and I proposed basically the same solution. Are you looking for an explanation on why this happens or a fix :sweat_smile:

Correct me on this one fellas but an empty list does not necessarily imply a count of zero, it could just be null which would essentially break your 2nd condition causing the inconsistency you observed.

So if you replace count is 0 with β€˜is empty’ you might fix the problem, try it and let me know

1 Like