||"Navision Construction"||"NL","Allunique","Dimension Value Combination","Dimension 1 Value Code","DataSource=","Navision Construction","Dimension 1 Code","BRANCH","Dimension 2 Code","DIVISION","Dimension 2 Value Code","00","","","","","","","","","","","",""
filters for values that are in a blocked combinations file (Branch Division)
NL("Rows","Dimension Value",,"DataSource=","Navision Construction","Dimension Code","BRANCH","Code",$E$5)
Brings back records tath are blocked from the filter however I need
NL("Rows","Dimension Value",,"DataSource=","Navision Construction","Dimension Code","BRANCH","Code","<>"&$E$5)
as I want the value that are not blocked and Jet does not seem to like the <> on a filtered item
What am I missing ?
0 comments
Please sign in to leave a comment.