NL Sum as filter in a NL filter

I need your help on my formula.  I need a NL filter with all dealers who bought more than 1000€ last year.

So my try:

=NL("Filter";"Customer";"Nº";NL("Sum";"Cust. Ledger Entry";"Amount";"Posting Date";"010117..311217";"Salesman code";1;"Document type";"Invoice";"Customer Nº";NF(;"Nº"));">0")

This is not working, I think the  problem is on the ;NF(;"Nº"))...

What do you think??

PS(I'm spanish so sorry if any field has a "weird" name, I tried to translated but I'm not sure that is the right name on NAV versions)


Please sign in to leave a comment.