Jet Basic - filtering for a specific value in a linked table

(0) Share

Report

Posted on by themanjosh

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.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

Try this link to the Jet Report website Community assistance: help.insightsoftware.com/.../jet

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No