I tried to use the next formula but is doesn''t work:=NL("Rows";NP("Union";NL("Filter";"Projectpost";"Phase Code";"Projectnr.";$C17;"Element";$D17;"fCodStructLineNo";"@@"&$J$10);NL("Filter";"Projectpost";"Phase Code";"Projectnr.";$C17;"Element";$D17;"Nr.";$J$12);NL("Filter";"Projectstructuur regel";"fCodPhase";"Projectnr.";$C17;"fCodStructElement";$D17;"Nr.";$J$10;"Versie";"100")))
I want values ("Phase Code") from the table "Projectpost" with filter on "Nr." or "fcodstruclinno" and values from the table "Projectstructuur regel" wiht filter on "Nr." and for all tables the filter on "Projectnr." and "element"
The formula is too long or I can't make a union function with 3 filters. How can i realise this?
With kind regard, Norbertus
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment You are correct about the formula being too long, however you can have more then 2 arrays to Union.
In you formula I would put each NL("Filter") in its own cell and reference all 3 cells in the NP("Union")
For example;=NL("Rows";NP("Union";B3,C3,D3) Cell B3 =NL("Filter";"Projectpost";"Phase Code";"Projectnr.";$C17;"Element";$D17;"fCodStructLineNo";"@@"&$J$10) Cell C3 =NL("Filter";"Projectpost";"Phase Code";"Projectnr.";$C17;"Element";$D17;"Nr.";$J$12) Cell D3 =NL("Filter";"Projectstructuur regel";"fCodPhase";"Projectnr.";$C17;"fCodStructElement";$D17;"Nr.";$J$10;"Versie";"100"))) -
Jet Reports Historic Posts thanks, it works
Please sign in to leave a comment.