0

Nested NP function within an NL function

Jet Reports Historic Posts

September 07, 2015 18:09

None

Follow

=NL(NP("Companies","AC Ltd"),"Lease",$D$4:$E$4,"Headers=",$D$3:$E$3,"TableName=","Lease","IncludeDuplicates=","True")

Three assumptions:
- You are trying to build an excel table object from the table 'Lease'
- The fields in the table are in $D$4:$E$4
- NP("Companies","AC Ltd") returns just ONE company name

If those are true, try
NL("Table","Lease",$D$4:$E$4,"Headers=",$D$3:$E$3,"TableName=","Lease","IncludeDuplicates=","True";"Company=";NP("Companies","AC Ltd"))
But the NP in the end ins't really necessary.
You can just put the company name in there.

HTH

rmw

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 07, 2015 18:09

  I'm trying to retrieve rows from a table across multiple NAV companies - I am using the formula =NL(NP("Companies","AC Ltd"),"Lease",$D$4:$E$4,"Headers=",$D$3:$E$3,"TableName=","Lease","IncludeDuplicates=","True") - AC Ltd is a valid company but different from the one shown in the Jet Ribbon. I have 20 plus companies I want to do this for. From reading the forum it sounds possible. Any help would be appreciated.

• 0
  
  Jet Reports Historic Posts September 09, 2015 18:16

  thanks - does not seem to work. I've records on the same table in one NAV company and in another company and I want to output them. Any ideas how pls?