0

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

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

2 comments

Please sign in to leave a comment.