Hello,
Trying to retrieve a list of items with a filter that excludes items based on a wildcard search.
=Nl("rows";"Item";"No.";"No.";"<>*.5*")
The filter does not seem to work.
I just checked and realise that you cannot do this in Navision itself either… Which is probably the cause…
Anyone have any ideas to do this in an alternative way?
Thanks!
Date
Votes
1 comment
-
Jet Reports Historic Posts Interesting question… the item no. is a code type of field (i.e. alphanumeric)… and you want to exclude any item no. that has ".5" on any position… right?
Well, how about creating an array with all item nos, creating an array with the .5 items only, and compare the 2 to get the difference of these arrays…
- Filter All items: NL("Filter","Item","No.")
- Filter .5 items: NL("Filter","Item","No.","No.","*.5*")
- Display all items except the .5 items: NL("Rows", NP ("Difference", CellRefToFilterAllItemnos, CellRefToFilter.5Items))
I'm doing this by heart, so please let me know how this works.
Please sign in to leave a comment.