I want to sum sales by customer from the customer table using my base currency. This requires looking at the posted sales invoice header table and multiplying the currency factor field by the amount field. Then NL(sum) the result of this calculation for all sales that are specific to the and returning that amount. A simple NL(Summ) is what I would normally use but the fact I need to do a calculation first has stumped me. Is there a way to do a calculation first and then sum?
Date
Votes
1 comment
-
Harry Lewis Hello Gerald -
While it can get a bit complex (depending upon your calculation), it should be possible.
If you are using Dynamics NAV, the technique is defined in Sort by Sum (or Count) with Dynamics NAV.
Please sign in to leave a comment.