Hi,
I like to know if it`s possible to set a filter in the first NL function that look at multiple tables with the same outcome. For example:
=NL("Rows";"Artikel";;"Artikelstatus";"<>4 VERV";"Nr.";$I$11)
=NL("Rows";"Artikel";;"Artikelstatus";"<>4 VERV";"Nr.";$I$11;"Aantal in verkooporders"|"Aantal in serviceorder"|"Aantal op assemblageorder"|"Aantal in prod.-orders"|"Aantal in materiaalregels";"<>0")
It’s all about filtering in an early stage so you don`t need the records that don`t have material requirement.
I tried to do it with the | sign, bud this is not working.
Is there someone that has a good solution for this?
Thanks in advance.
Date
Votes
2 comments
-
Jet Reports Historic Posts Is there nobody that have a solution for this problem? :(
Our is my question to vague….. -
Jet Reports Historic Posts I am not sure I understand your question, but let me try.
You want to filter the table Artikel based on the tables "verkooporders", "serviceorder", "assemblageorder", "prod.-orders", and "materiaalregels". What is the relationship between these tables? (ie what is the field in common in all of these tables?
It sounds like you need to use either a Link= or NL("Filters"), but I think we need more information about what you are trying to do.
Please sign in to leave a comment.