filtering from different tables

Hello,
I have a complex report that I need help with
It uses two separate tables but needs to filter based on calculated values
the first table is the sales price worksheet
the second table is the item table
i want a new sheet for each sales code value in the sales price worksheet
i want the nl rows to list items where the current unit price<> unit cost times a constant and the constant depends on the sales code value
I DO NOT want to use the hide function
Here are some of the functions I have tried so far and none filter out the values where current unit price=unit cost times the constant
c3=NL("Sheets","Sales Price Worksheet","Sales Code")
c4=NL("Filter","Sales Price Worksheet","Item No.")
=NL("Filter","Sales Price Worksheet","Item No.","=NF(,""Current Unit Price"")/NL(""First"",""Item"",""Unit Cost"",""No."",NF(,""Item No.""))","NUMBER&<>1.025..1.0354","Sales Code","$C$3)
each time i run this report it lists all items with no exclusions
help!
:?