0

Version No.

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

1 comment

Please sign in to leave a comment.