Hi everyone,
I have a report that i use which is successful, however when I try to sort by "Sell-To Customer Name" I get an error.
$B$2: is an option which can be any salesperson code…Default is Asterix "*"
$C$2: is an option which can be any item category code…I am trying it with C1050
$B$5: is the Header formula
$C$5: is the Line formula
with various NF's along the line.
My Formula was=NL("Rows","Sales Header",,"+Salesperson Code",$B$2,"Document Type","Order","Status","Released","No.",NL("Filter","Sales Line","Document No.","Document Type","Order","Type","Item","Outstanding Quantity","<>0","Item Category Code",$C$2))
Then I added in the Sort=NL("Rows","Sales Header",,"+Salesperson Code",$B$2,"+Sell-To Customer Name","*","Document Type","Order","Status","Released","No.",NL("Filter","Sales Line","Document No.","Document Type","Order","Type","Item","Outstanding Quantity","<>0","Item Category Code",$C$2))
and I get an error
the formula on sheet "Back Order" in address $B$5 cannot be used with NL(Rows), NL(Columns), or NL(Sheets). Your report may be too long, or your formula may contain both Nested functions and named ranges. Excel has a worksheet limit of 65536 rows and 256 columns. Both you cannot use both nested functions and named ranges in the same formula.
I dont know why this gets an error.
the first Formula returns 20 lines.
and there isn't more than 10 filter pairs.
Please help.
:(
-Bromy