I have three different companies (CO, COII, COIII). In each company I have several funds. I want to create a NL(Filter) for all funds in all companies. It's easy to create a filter for each company, but how to I combine all the filters into one filter? I tried the text below, but with no success.=NL("Filter",NP("Union",$C$3,$C$4,$C$5))
where cell C3 contains filter NL("Filter","Fund","No.","Company=",CO)cell C4 contains filter NL("Filter","Fund","No.","Company=",COII)cell C5 contains filter NL("Filter","Fund","No.","Company=",COIII)
Any suggestions would be greatly appreciated.
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment I received an answer and solution to the question above question from Jet Reports. I hope the information below is helpful. Thanks you to Jet Reports for their assistance!
Answer from Jet Reports:
Unfortunately we can’t embed an NP(Union) function inside an NL(Filter), so we have to have create a string of values.
To create the string we have to place the NP(Union) inside an NP(Join) inside the NL(Filter) function. For example, you already have the 3 NL(Filter) functions pulling the fund numbers from each company:
Company 1: =NL(Filter,TABLE,Fund No.,Company 1)
Company 2: =NL(Filter,TABLE,Fund No.,Company 2)
Company 3: =NL(Filter,TABLE,Fund No.,Company 3)
Now, you have another NL(Filter) function that you want to place the NP(Union) inside of. For example:=NL(Filter,TABLE,FIELD,”Fund No.”,NP(“Join”,NP(“Union”,$C$5,$C$6,$C$7),”|”))
That will bring back an array of values using the combined fund numbers from the union. However, you have to make sure that the NP(Join,NP(Union),”|”)) function is placed in a FILTER parameter and not the TABLE, FIELD, or FILTERFIELD parameters.
Please sign in to leave a comment.