0

Embedded NL(Sum) function within an NL(Filter) function

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.