Hello,
While building a short report I encounter a problem.
The formula:
=NL("Rijen";"Sales Line Archive";;"Document No.";"SO911*";"Responsibility Center";"Parts";"Type";"Item")
The result:
Document No. /Document Type /Responsibility Center /Line No. /Version No.
SO91101 /Order /PARTS /20000 /1
SO91101 /Order /PARTS /30000 /1
SO91101 /Order /PARTS /40000 /1
SO91101 /Order /PARTS /20000 /2
SO91101 /Order /PARTS /30000 /2
SO91101 /Order /PARTS /40000 /2
SO91101 /Order /PARTS /20000 /3
SO91101 /Order /PARTS /30000 /3
SO91101 /Order /PARTS /40000 /3
SO91101 /Order /PARTS /20000 /4
SO91101 /Order /PARTS /30000 /4
SO91101 /Order /PARTS /40000 /4
In this case we do not need the old versions (1-3), we only need version 4. I tried the "Last"" and "-1" filters, but that did not solve the problem. does anyone know a solution?
Kind regards,
Michel
Date
Votes
1 comment
-
Jet Reports Historic Posts My first thought would be to break the function up.
Start with
B2=NL("Rijen";"Sales Line Archive";""Document No.";"Document No.";"SO911*";"Responsibility Center";"Parts";"Type";"Item")
This 'should' give you a unique list of all Document No.
Then to another NL:
C2=NL("Last";"Sales Line Archive";;"Document No.";B2;"+Version No_","*","Responsibility Center";"Parts";"Type";"Item")
Note the + in front of version to sort, and the Last to grab the latest version
Then use NFs on C2
C3=nf(C2,"Document Type")
etc
I'm not able to test this for you right now… so I can't be sure it'll work.
Good luck.
Mark
Please sign in to leave a comment.