0

Combining 2 filters into 1

Jet Reports Historic Posts

March 09, 2011 15:33

None

Follow

In C3 I have, say, =nl("Filter", "Item", "No.", < criteria stuff 1>)
In C4, =nl("Filter", "Item", "No.", < criteria stuff 2>)

In C5, what I would like to do is
=NL("Filter", "Item", "No.", "No.", np("Intersect", C3, C4)), but that gives me the dreaded, "an array is not a valid argument…" error.

How do I turn C5 into a filter that is the intersection of C3 and C4? Note that I cannot do:
=NL("Rows", "Item", "No.", "No.", np("Intersect", C3, C4)) because I do not want rows to be replicated.

Thanks in advance.

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts March 09, 2011 16:58 Official comment

  After a lot of searching, I finally found the answer here:
  
  http://community.jetreports.com/viewtopic.php?f=7&t=1328&p=3694&hilit=filter#p3694

• 0
  
  Yvonne Jury January 31, 2018 20:49

  Is the article still available?  The link is not working.

• 0
  
  Harry Lewis January 31, 2018 21:14

  Hi Yvonne.

  That isn't a link to an article, it's a link to post in the (former) Jet Community Site.  Unfortunately, there is no way of knowing to what post that link went.  However, the post itself would be here on this community site... somewhere.

  Edited by Harry Lewis January 31, 2018 21:15