0

Conditional NL Function with child table

Jet Reports Historic Posts

January 19, 2015 19:14

None

Follow

Can someone please explain , why when using a conditional IF , only a SINGLE row from the child Table is being returned.
I am guessing it has to do with the way the row replicators work. Attached please find the file which illustrates the problem.

This is what I have in Cell C3 (returns all rows from the Repack Order Table)
=NL("Rows", "Repack Order")

Cell D3 ( Returns the No. field from the Repack Order)
=NF($C3,"No.")

Cell E3
=IF(C3="",{""},NL("Rows", "Repack Order Line" , , "Order No.",D3))

In the event that I remove the IF C3="" check , I get back the result I am expecting

• Problem.xlsx

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 20, 2015 07:40

  Try:
  
  NL("Rows",IF(C3="",{""},NL("Filter", "Repack Order Line" , , "Order No.",D3))
  
  NL("Rows") seems to need to be the first thing in the cell.

• 0
  
  Jet Reports Historic Posts January 20, 2015 11:52

  Try this
  {} wont work try after removing the {} brackets
  
  =IF(C3=""," ",NL("Rows", "Repack Order Line" , , "Order No.",D3))
  
  I think this should work….
  
  Alex :)