Incorrect sum result from NL formula

The following formula once provided me with the correct result and no longer does.  I've tested where the breakdown is happening by stripping away one filter and then another find that I still have a problem when removing all of them. When removing all of them, I sometimes get a result that might be correct, but it can take more than hour to get it. Here is the whole formula.  By the way, other reports seem to be working that use other formulas and other tables.

=NL("sum","sales invoice line","Amount","Type","Item","Shipment Date",">12/31/2016","Document No.",NL("Filter","Sales Invoice Header","No.","Order Date",np("eval","options!c$4")))

1 comment

Please sign in to leave a comment.