I'm trying to calculate the total weight of items sold, so I need to sum([Item Ledger Entry].[Quantity] * [Item].[Net Weight]). Is there a way to do this?
Date
Votes
2 comments
-
Jet Reports Historic Posts Yeah you can use a calculated field, similar to the calculated filter field we worked on earlier but a bit more complicated. Are you trying to do this sum for each item? If so, assuming your item numbers are in cell C5, you might do something like this:
=NL("Sum","Item","=NF(,""Net Weight"")*NL(""Sum"",""Item Ledger Entry"",""Quantity"",""Item No."",NF(,""No.""))","No.",C5)
Of course if you were just doing this item by item, then you could easily split out the NF and the sum from the Item Ledger Entry and just multiply them together. However, with this formula, you could actually filter for multiple item numbers in C5 and get your answer without replicating them out. Of course, I may be missing how you want to do this entirely as well.
Regards,
Hughes -
Jet Reports Historic Posts I will try that. Thank you.
For the record, I'm not doing this item by item. I'm calculating totals for item categories without displaying the individual item numbers.
Please sign in to leave a comment.