Have the following item table:
B3 =NL("rows";"Item";)
C3 =NL($B3;"No.";)
D3 = NL("Sum";"Stockkeeping Unit";"Inventory";"Item No.";$C3;)
Would like to filter out any item with less then 10 pieces in stock.
I've done it with Hide+? but I prefer a direct filter, but have no idea how to filter on a sum field!
Thanks for any help!
Date
Votes
1 comment
-
Jet Reports Historic Posts I had this same(similar) question a while ago. Have a look at this post:
http://community.jetreports.com/viewtopic.php?f=7&t=310&st=0&sk=t&sd=a
Basically you embed the 'sum' formula within the original NL, but you escape the quotes with double quotes, and a few other differences, such as the use of & characters.
I know my post was a little different, but I think you should be able to use the same technique (just without the sorting options).
Please sign in to leave a comment.