I have a report where I do not want to include any item numbers where the 8th & 9th char's are PE or RE. CR9, PSQL9
Server 2003.
This is my formula:
(not ({IMITMFIL.ITEM_NO} startswith ["ALMISC", "ALSCRAP", "AWELD"])) and
{IMITMFIL.ITEM_NO} >= "A%" and
{IMITMFIL.ITEM_NO} <= "AZ%" and
(not ({IMITMFIL.ITEM_NO}[8 to 9] in "PE")) or (not ({IMITMFIL.ITEM_NO}[8 to 9] in "RE")) and
{@QtyNotSold} > 0.00 and
{IMITMFIL.ITEM_MFG_LOC} = "01"
Obviously what I'm trying is:
(not ({IMITMFIL.ITEM_NO}[8 to 9] in "PE")) or (not ({IMITMFIL.ITEM_NO}[8 to 9] in "RE"))
but it's returning all item numbers.
Thank you for any assistance.
Gene
Server 2003.
This is my formula:
(not ({IMITMFIL.ITEM_NO} startswith ["ALMISC", "ALSCRAP", "AWELD"])) and
{IMITMFIL.ITEM_NO} >= "A%" and
{IMITMFIL.ITEM_NO} <= "AZ%" and
(not ({IMITMFIL.ITEM_NO}[8 to 9] in "PE")) or (not ({IMITMFIL.ITEM_NO}[8 to 9] in "RE")) and
{@QtyNotSold} > 0.00 and
{IMITMFIL.ITEM_MFG_LOC} = "01"
Obviously what I'm trying is:
(not ({IMITMFIL.ITEM_NO}[8 to 9] in "PE")) or (not ({IMITMFIL.ITEM_NO}[8 to 9] in "RE"))
but it's returning all item numbers.
Thank you for any assistance.
Gene