Formula too long


I have created a formula that lists items in a filtered list of posted sales invoices but the formula is too long - 306 characters!

Is is possible to write a NL function to produce list of Sales Invoice Headers numbers as:
NL("AllUnique","Sales Invoice Header","No.","Posting Date",$D$3,"Sell-to Customer No.","@@"&"WG10831",,,,,,,,,,,,,,,0,"Faupel Home Furnishings")

into (say) cell J1 in a spreadsheet and then set a filter on Sales Invoice Line formula (say in cell D15) as:

FilterField1: "Document No."
Filter1: $J$1

This would reduce the number of characters to Excels allowable limits.

I have tried this but cannot get it to work.

Moe Sembi


Please sign in to leave a comment.