I'm trying to set up a Rows filter on the Value Entry table to find lines with Item Charge No. that isn't blank and doesn't start with a specific string (e.g. "PRO ").
If I use ">''" then I get the non-blank values OK.
If I use "<>PRO *" then I get anything that doesn't start with "PRO "
If I try combining these, I get no lines… I've tried ">''&<>PRO *" and "<>PRO *&>''" and even things like "<>'PRO '*&>''" but I get nothing each time.
I can't set 2 filters on the same field and there's no other way to identify these lines, so how can I achieve this?
Date
Votes
2 comments
-
Jet Reports Historic Posts I would filter using "<>PRO*&<>@@"
Let me know if that works? -
Jet Reports Historic Posts I would filter using "<>PRO*&<>@@"
That didn't work for me. I figured it out by doing this in another cell:
Let me know if that works?=NL("Filter","Item Charge","No.","No.","<>PRO *")and then referencing this in the filter in the other cell.
Please sign in to leave a comment.