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")))
Date
Votes
1 comment
-
Harry Lewis Hello Brad -
As there nothing inherently wrong with the structure of you query, you would want to submit a support request so that a trained analyst could help you examine why you are not getting the results you expect.
Please sign in to leave a comment.