Hi all,
I'm trying to get a filter to work as I want, but alas.
First an outline of what I want:
All employees in our table '5200 - Employee' have a field 'Manager No.' I want to filter this table so I get the unique Manager No.'s which I then want to use as input in a Lookup-function on the table '156 - Resource'.
I don't want to let users scroll through all resources in order to find the manager; a shortlist is preferrable.
So I built the Lookup function as follows:=NL("lookup","Resource",{"No.","Name","Global Dimension 1 Code"},"No.",NL("Filter","Employee","Manager No."))
This results in a JetEssentials error stating that it is an 'invalid Lookup formula' (screenshot is attached).
What am I doing wrong here?
Thanks in advance,
Willem
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment I did something similar (because I don't have any Manager No. in my DB) but my test worked.
=NL("lookup","Customer",{"No.","Name"},"No.",NL("filter","Cust. Ledger Entry","Customer No."))Bring back a list of Customer No and Name but only show customer numbers that are found in my Cust. Ledger Entry Table.
My guess is that there aren't any Manager No. in your Employee table that match any Resource No but without seeing the report, it is hard to tell.
Are you able to post the report for review? -
Jet Reports Historic Posts Hi JET-btr,
Thanks to your reply I was able to find what was wrong. :P
Adding an extra filter on the Employee table proved to be the solution.
Now it's working the way I wanted.
Thanks anyway,
Willem
Please sign in to leave a comment.