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.