Hello,
I had a question - I am trying to build a report where I can get my sales numbers in the sales unit of measure, which is different from the base unit of measure. I am using the Jet sales basic report Item sales and Profit as a starting point
The table function is as follows
=@NL("Table","27 Item",$E$11:$AA$11,"Headers=",$E$10:$AA$10,"TableName=","Item","Filters=",$C$5:$D$7,"InclusiveLink=27 Item",$F$9,"IncludeDuplicates=","True")
The link is here
=@NL("Link","5404 Item Unit of Measure",,"1 Item No.","=1 No.")
and the field I am displaying is
=@NL("LinkField","5404 Item Unit of Measure","3 Qty. per Unit of Measure.")
What my goal is is to ensure that the linkfield is pulling the number from CODE = CASE from the item unit of measure field. I have tried putting a filter in a bunch of places, but admittedly am a bit of a beginner at this and might just be getting a syntax error or am missing something else.
If someone could assist me I would really appreciate it.
Hello,
Try this link to the Jet Report website Community assistance: help.insightsoftware.com/.../jet
Hope this helps.
Thanks,
Steve
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148