When in Jet I am currently building a report to display data based on a parent table.
I am then using link to help further filter the table.
Ideally I want to return several fields based on a Link to the item table where the description is Motor or the Item class is Motor.
The below function only gives me the items which match both criteria.
=NL("Table","ItemAggregate",{"Description","ItemNo","KitOrderQty","KitQtyCommit","LocationCode","Manufacturer Name","Mfr. Part No.","QtyCommit","QtyOnHand","TransferQtyCommit","Unit Cost"},"TableName=","ItemAggregate","IncludeDuplicates=","True","QtyOnHand",">0","Link=","Item","No.","=ItemNo","Description","*MTR*|*MOTOR*","Class","MOTORS")
How can I use an OR operator in the filter list?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello.
I don't think there is any way to do this using a table. You would need to build the function using row replicator functions with a Filter function to combine the results. -
Jet Reports Historic Posts Hello,
Agree with Jason, not sure if this is possible with a Table, but should be possible using Filters and a Union formula:
Create one filter for each condition:
B2=NL("Filter","ItemAggregate","ItemNo","Description","*MTR*|*MOTOR*")
B3=NL("Filter","ItemAggregate","ItemNo","Class","MOTORS")
Create a row replicator that uses the union of the two filters above as a filter on the Item No.:
B4=NL("Rows","ItemAggregate",,"ItemNo",NP("Union",$B$2,$B$3),"QtyOnHand",">0")
Then use NF formulas to get the data for the other fields.
C4=NF($B4,"KitOrderQty") …etc.
Regards,
Rob
Please sign in to leave a comment.