0

NL nested NL with NF

Pablo Álvarez

May 02, 2018 13:30

None

Follow

HEllo,

I would like to get a filter with all nº of customers who bought more than 100$

My try:

=NL("Filter";"Customer";"Nº";"NL(""Sum"";""Mov. customer"";""Sales"";""Nº customer"";NF(;""Nº"");""Date"";""010118..311218"")";">100")

 

But it doesn't work.... where is the problem?

Thank you!

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis May 07, 2018 16:53

  Hello Pablo -

  Although I am not familiar with the "Mov. Customer" table, I think you are simply missing an equal sign (=) in front of your NL(Sum) function:

  =NL("Filter";"Customer";"Nº";"=NL(""Sum"";""Mov. customer"";""Sales"";""Nº customer"";NF(;""Nº"");""Date"";""010118..311218"")";">100")

   

• 0
  
  Pablo Álvarez May 08, 2018 08:00

  Hello HArry,

  thank you for your answer.  Finally I fix the situation with this:

  =NL("Filter";"Customer";"Nº";"=NL(""Sum"";""Mov. customer"";""Sales"";""Nº customer"";NF(;""Nº"");""Date"";""010118..311218"")";"NUMBER&>100")

  You were right with the = but the trick was the NUMBER& just to make jet reports interpretate >100 as number instead of a string.