0

is this right for link= and a date range ?

What I am trying to accomplish is this.
Look to the opportunity table, and if they are a new customer in the opportunity table (based off the posted sales invoices 'posting date' range, in my link=), then have them show up on the report if they have a posted inovice.

In Cell G10. =NL("Filter","Opportunity","Contact Company No.","Salesperson Code",$B$3,"Campaign No.","CCI","Closed","False","Link=","Contact Business Relation","Contact No.","=Contact Company No.","Link to Table","Customer","Link=","Sales Invoice Header","Sell-To Customer No.","=No.","Posting Date",NP("Datefilter",$J10,$K10))

In Cell H10. =NL("Filter","Opportunity","Contact Company No.","Salesperson Code",$B$3,"Campaign No.","CCI","Closed","False","Link=","Contact Business Relation","Contact No.","=Contact Company No.","Link to Table","Customer","Link=","Sales Invoice Header","Sell-To Customer No.","=No.","Posting Date",NP("Datefilter",,$J10-1))

In Cell M10. =NL("CountUnique",NP("Difference",$G10,$H10))

It doesn't seem to work for me …

Does anyone have any thoughts ?

0 comments

Please sign in to leave a comment.