Is your NL("Filter") meant to be in quotes - I wouldn't have done?
NL("som";"artikelpost";"Aantal";"Artikelnr.";$C11;"Boekingssoort";"verkoop";"Documentsoort";"Verkoopverzending";"Boekingsdatum";$H$7;"Bronnr.";NL("Filter";"custumor";"Nr.";"Klantenprijsgroep";"xx"))
If it is, all the quotes inside it need to be double (""), but that doesn't seem right to me.
NL("som";"artikelpost";"Aantal";"Artikelnr.";$C11;"Boekingssoort";"verkoop";"Documentsoort";"Verkoopverzending";"Boekingsdatum";$H$7;"Bronnr.";"NL(""Filter"";""custumor"";""Nr."";""Klantenprijsgroep"";""xx"")")
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Can somebody tell me what is wrong with following filter
The result must be the sum of "aantal" where customers belong to klantprijsgroep XX
bronnr. from artikelpost table = nr. from customer tableNL("som";"artikelpost";"Aantal";"Artikelnr.";$C11;"Boekingssoort";"verkoop";"Documentsoort";"Verkoopverzending";"Boekingsdatum";$H$7;"Bronnr.";"NL("Filter";"custumor";"Nr.";"Klantenprijsgroep";"xx")")
thanks -
Jet Reports Historic Posts Hello Jan -
Is this the same function?=NL("sum","32 Item Ledger Entry","12 Quantity","2 Item No.",$C11,"4 Entry Type","Sales","79 Document Type","Sales Shipment","3 Posting Date",$H$7,"5 Source No.",NL("filter","18 Customer","1 No.","23 Customer Price Group","xx"))
What issue are you experiencing? If the function returns a #VALUE!, what details are displayed when you select the cell and click the DEBUG button on the Jet ribbon?
-HP
Please sign in to leave a comment.