0

Formula too long

Hello,

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.

Regards
Moe Sembi

2 comments

Please sign in to leave a comment.