Hi,
I am trying to Sum the KG's sold during a date range.
Our Items have different Base Units of Measure, eg, KG, CTN, PKT, EA etc. The only way I can convert to a common weight is to multiply the Qty Sold by the weight on the Item Unit of Measure
I have had an attempt to link the tables but have had no success., please see below.
=nl("Sum","Item","=NF(,""Sales (Qty.)"",""Date Filter"","""&$H$4&""",""Location Filter"","""&$C$88&""")*nl(,""Item Unit of Measure"",""Weight"",""Item No."",nf(,""No.""),""Code"",NF(,""Base Unit of Measure"")")
I am using Nav 2009 and Jet 11.1.12053.0
Any help would be appreciated.
Regards
Phil
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Phil,
I'm not positive whether the actual calculated field will do what you want, but I know that it is currently missing a final closing parenthesis. So it needs to be this:=nl("Sum","Item","=NF(,""Sales (Qty.)"",""Date Filter"","""&$H$4&""",""Location Filter"","""&$C$88&""")*nl(,""Item Unit of Measure"",""Weight"",""Item No."",nf(,""No.""),""Code"",NF(,""Base Unit of Measure""))")
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
When I try and run the function I get "Empty Filter not Allowed".
Regards
Phil -
Jet Reports Historic Posts Hi Phil,
Well, that means there is an empty filer because something is returning a blank. Either there is a blank in cell H4 or C88 of your workbook or else one of the nested NF functions in the calculated field is returning a blank value (such as Base Unit of Measure on the Item table).
Regards,
Hughes
Please sign in to leave a comment.