Filtering on two <>s returns values but multiple <>s returns invalid filter

The formula below works fine when Agreement code (Dimension 8) is a long list of Agreement codes (48100,69200,74200,77200, etc) and also work s for one or two <>s (<>@@&<>5600.  But the formula returns "Invalid filter" if an additional &<> value (<>@@&<>5600&<>7400) is added.   Is there a way to filter on Dimension 8 with multiple <>s?

=IFERROR(-NL("Sum","Version Line Detail",BI$7,"0",BI$4,"Agreement Code",$E75,"Date",BI$8,"Fund No.",BI$10,"Budgeting Code",BI$13,"G/L Account No.",$I75),0)


Please sign in to leave a comment.