Is it possible to embed an NL SUM function within an NL FILTER function?
I am trying to create a filter that will only returns job no.'s that have a dollar value sum <>0 within a certain date range.
The filter is used for two different companies and is combined in a union that is used by an NL ROW function to create a list of job numbers.
Here is a sample of the code I have so far:
=NL("Filter","Job Ledger Entry","Master Job No.",0,$C$2,"Posting Date",$C$7,"Master Job No.","<>C*&<>I*&<>S*&<>W*&<>*R*&<>*W*&<>*I*&<>''", "=NL(""Sum"",""Job Ledger Entry"",""Line Amount"",0,"""&$C$2&""",""Posting Date"","""&$C$7&""",""=NF(, ""Master Job No."")"")+NL(""Sum"",""Job Ledger Entry"",""Total Cost ($)"",0,"""&$C$2&""",""Posting Date"","""&$C$7&""",""=NF(, ""Master Job No."")"")", "<>0")
Any suggestions is greatly appreciated,
-Tyler
0 comments
Please sign in to leave a comment.