I have an NP union which returns a set of document numbers. I then want to filter on those returned document numbers to only get the line numbers from those documents where the current batch owner is equal to D2, or the new batch owner is equal to D2. I get #VALUE in the cell where I'm entering the formula. Is my syntax incorrect, or is this even possible? I've tried it two different ways below:
=NL("Rows","posted work order line",,"document no.",NP("Union",$E$14,$E$15,$E$16),"line no.",NL("Filter","posted work order line",,"document no.","=nf(,document no.)","Current batch owner",$D$2),"line no.",NL("Filter","posted work order line",,"document no.","=nf(,document no.)","New batch owner",$D$2))
=NL("Rows","posted work order line",,"document no.",NP("Union",$E$14,$E$15,$E$16),"line no.","=NL(""Filter"",""posted work order line"",,""document no."",""=nf(,document no.)"",""Current batch owner"","""&$D$2&""")","line no.","=NL(""Filter"",""posted work order line"",,""document no."",""=nf(,document no.)"",""New batch owner"","""&$D$2&""")")
