I'm simply trying to find customer accounts that did not purchase anything in 2015. I tried the following:=NL("Rows","Customer",,"Salesperson Code",$C$2,"Date Filter","01/01/15..12/31/15","Sales ($)","0")
But it keeps returning all of the customers for the sales rep, even ones with sales. I'm assuming the Date Filter is not working correctly or the Sales ($) field is the wrong one to use..
Anyone know of a good way to do it?
Date
Votes
2 comments
-
Jet Reports Historic Posts Have you considered counting how many transaction records each customer has?
=NL("Rows","Customer",,"=NL(""Count"",""Cust. Ledger Entry"",,""sell-to customer no."",NF(,""No.""),""Posting Date"",""1/1/2015..12/31/2015"")","NUMBER&>0") -
Jet Reports Historic Posts I tried something similar but it increased the run time a lot. Just ended up doing multiple NL Filters for invoices and credits with a Union and a Difference to get the list of customers with no sales. Basically the same thing but seems to run a lot faster.
Thanks for the help!
Please sign in to leave a comment.