Jet Reports: Filter by a sum

NAV/BC Data Sources: An example

1. Create an NL(Sum) function that sums quantity by location. Then, apply "Quote" to the function:="=NL(""Sum"",""Item Ledger Entry"",""Quantity"",""Location Code"",NF(,""Location Code""))"

2. Refer to the above function via a cell refence in the filterfield parameter of your main NL formula and apply the desired number filter in the filtervalue parameter, e.g. where sum of quantity in each location is not zero:=NL("Filter","Item Ledger Entry","Location Code",$C$6,"NUMBER&<>0")

Data Sources Other Than NAV/BC: An example

1. Filter on the sum of a field directly in your main NL function, e.g. where net change over a period is not zero:

   
   

   =NL("Filter","Finance Transactions","GL Account No","Posting Date",$Y$7,"Sum(Amount)","<>0")