0

NL columns returns a single data while NL rows returns multiple data.

Alessandro Mondaini

August 05, 2020 08:18

None

Follow

Hi all,

I'm trying to create a Jet report using an NL(Columns) to display a series of items according to a filter in a cell (CO-11031|CO-11033|CO-11036|...).

My NL(Columns) function displays only one item, but if I do an NL(Rows) it displays all items.

You will find some screenshots showing the problem :

• =NL("Rows";"Article";"N°";"N°";Option!C84)

• =NL("Columns";"Article";"N°";"N°";Option!C84)

• Filter

Could someone help me solving this problem ?

Thanks

Alessandro

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Bryan Robinson August 10, 2020 21:10

  Hi Alessandro, it is a bit hard to be able to diagnose the issue without being able to look at the report or the underlying functions.  I would suggest reaching out to your closest Jet services provider to review the work you have done.

• 0
  
  Alessandro Mondaini September 14, 2020 07:48

  Hi Bryan,
  First of all let me thank you for your answer.

  I contacted my Jet service provider who had no ideas on how to correct the problem.

  With a little more research, I think I was able to identify the problem. It seems to be coming from the filter which is too long to be processed by the NL function.