filter with wildcard ("<>*.5*")


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?


1 comment

Please sign in to leave a comment.