0

Filter a table based on another table using nested NL

Jet Reports Historic Posts

May 23, 2013 15:15

None

Follow

Greetings, I am trying to return a string from the BV Version Line Worksheet table, filtered on Company ($I$4) and Plan No. ($I$5) but only when the Plan Level Reporting from the BV Version table matches my filter ($I$12). I have tried several formulas without success. Currently the formula I have (shown below) returns #Value! What have I missed? Thanks in advance, Bob T

=NL(,"BV Version Line Worksheet",,"0",$I$4,"Plan No.",$I$5,NL("Filter","BV Version","No.","Plan Level Reporting",$I$12))

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts September 02, 2013 10:59 Official comment

  Thanks for your reply. I switched from using the Filter function to using Link which accomplished my purpose with the following formula.
  
  =NL(,"Version Line Worksheet",,"0",$J$4,"Plan No.",$J$5,"link=","Version","No.","=Version No.","Plan Level Reporting",$J$17)

• 0
  
  Jet Reports Historic Posts May 24, 2013 06:06

  It seems there is a field (Plan Level Reporting?) missing where you filter with the nl-function.
  
  =NL(,"BV Version Line Worksheet",,"0",$I$4,"Plan No.",$I$5,YourFilterField,NL("Filter","BV Version","No.","Plan Level Reporting",$I$12))