Hi,
In order to calculate the Sum of All Invoice Lines with : The Dimension Value Code= "CENTRE" and Posting Date Between "01/02/2012..29/02/2012".
i made two filters,
First Filter : NL("Filtre";"COMPANY$Sales Invoice Header";"No_";"Posting Date";"01/02/2012..29/02/2012")
Second Filter : =NL("Filtre";"COMPANY$Posted Document Dimension";"Document No_";"Dimension Code";"REGION";"Dimension Value Code";"CENTRE")
How can i get All Invoice Line with Invoice Header In the Intersection of those two filters?
I tried the NP function, but it doesn't work?
I hope my problem is clear for you,
Thanks,
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment So assuming you had your 2 NL(Filtre) formulas in cells B2 and B3, your formula might look something like this:
=NL("Rows";"COMPANY$Sales Invoice Line";;"Document No_";NP("Intersect";$B$2;$B$3))
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Thanks, that works :)
Please sign in to leave a comment.