Hi,
i'm wondering a little bit why this doesn't work for me. as far as I know, NP(intersect) returns an array of values, so it should be possible to intersect that intersection.
I've uploaded an example which, hopefully, make things clearer ;)
thanks in advance
Michael
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Michael,
I don't have much time to search for a solution for you, but perhaps you can find your solution on the knowledge base of Jet: http://kb.jetreports.com/article/AA-00498/0/.
Good luck!
Regards,
Bert -
Jet Reports Historic Posts Hi Michael,
You should be able to use an intersect on another intersect. However any Jet formula which returns an array (NP(Union), NP(Intersect), NP(Difference) etc.) cannot be put in a separate cell and referenced. You have to actually embed it in the formula it's being used in. NL(Filter) doesn't return an actual Excel array; it just returns a string which Jet turns into an array later. So NL(Filter) can be put into a separate cell and referenced, but not functions that return actual arrays. Does this help?
Regards,
Hughes
Please sign in to leave a comment.