0

Filtering NL Function

Jet Reports Historic Posts

May 31, 2016 05:44

None

Follow

Hi All,

I'm trying to retrieve all POs "No." in the "Purchase Header" source table. However, I only want to retrieve "No." with the "Vendor Order No." beginning with text "CAP". I'm not sure on how to filter it with just that condition. Please help.

Thank you.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts May 31, 2016 14:38

  Hi -
  
  Try this:
  
  =NL("Rows","38 Purchase Header","3 No.","66 Vendor Order No.","CAP*")

• 0
  
  Jet Reports Historic Posts May 31, 2016 14:39

  NL("Rows","Purchase Header","No.","Vendor Order No.","CAP*")