I'm trying to come up with a list customers who haven't been sold in the last 21 days- or 35 days.
Any suggestions where to start?
Date
Votes
1 comment
-
Jet Reports Historic Posts You can do this using NP(Difference).
Basically, you are creating two arrays (lists) of customer #'s from posted sales invoices and subtracting one list from the other. Whatever is left, is the customers you haven't sold to lately.
The first array will be ALL the customers that have ever purchased from you. The second array will be only the customers that have ever purchased from you in the desired date range.
To create the arrays you would do something like this:
Array 1: NL("filter","sales invoice header","sold-to customer no.")
Array 2: NL("filter","sales invoice header","sold-to customer no.","posting date","03/01/10..03/31/10")
The order in setting up NP(Difference) is important. You want the list of all customers to be first. It would look like this: NP("Difference",Array 1,Array 2). The reference here to Array 1 and Array 2 would be whatever cells contained those NL("filter")'s. For example, NP("Difference",$D$4,$D$5)
To generate the actual customer numbers, you need to place it inside a replicator such as NL("rows"). It would then look like this: NL("rows",NP("Difference",Array 1, Array 2)
This is also a tip on the Jet Reports Support Site under the Knowledgebase Tips & Tricks
Please sign in to leave a comment.