0

Problem with NP("Intersect")

I have a filter that returns a list of numbers:

=NL("Filter","Estimation Entry","=VALUE(NF(,""Bill Item""))","Job No.","1234")

(The VALUE part is because they are stored as text values with leading zeros, don't ask).

Due to the problem with the data being stored as text, I then want to do an intersect on it with a list of numbers to provide some filtering:

=NL("Filter","Integer","Number","Number","0..14")

If I do a union of the 2 I get the expected results - a combination of the 2 (out of order but that's another issue)

=NL("Rows",NP("Union",Filter1,Filter2))

But if I do an intersect I get no values returned. I know there are values that appear in both sets.

=NL("Rows",NP("Intersect",Filter1,Filter2))

(Actually my problem is slightly more complex as I've got an extra union in there with another table, however - in my attempts to break down the problem I've found this simpler scenario that doesn't work).

Anyone got any ideas as to why it isn't working?

 

 

3 comments

Please sign in to leave a comment.