Good day…I have a question for you.
I have a report that ouputs date ranges
Jan. 04 - Jan. 08
Jan. 11 - Jan. 15
What I am trying to achive is this. If a customer has made a purchase within in the first date range, then show up in the report (count).
Now if the same customer has made a purchase in the second date range, I don't want it to show up.
I want my report to show only new customer purchases.
Please see the attached spreadsheet. The highlighted green cells are what i am working on.
Any suggestions?
NAV 5.0 SP1 DB
Jet 2009
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi cveale,
I think what you want here is NL("Difference",<List1>,<List2>). NL("Difference"…) returns a list of items in the first list that are not in the second. So if I have two lists of numbers List1 and List2. List1 has the integers 1,2,3 and List2 has 2,5 the NL("Difference of the two lists would be 1,3. My formula would look something like: =NL("Rows",NL("Difference",{1,2,3},{2,5})).
Your case is obviously a little more complicated but it would go something like this:
C3=NL("Filter"…) this should return the list of customers that purchased in the first date range.
D3=NL("Filter"…) this should return the list of customers that purchased in the second date range.
C6=NL("Rows",NL("Difference",$C$3,$D$3))
Does this help? -
Jet Reports Historic Posts This is exactly it. The only difference was that I had multiple date ranges.
I took the NL Filters and moved them down the my main NL line that gives me a multiple date ranges.
My report works great !!! Thanks.
Please sign in to leave a comment.