Need a function like "Not In Array"

[Parabolic33]

Hello,

I'm trying to find out if there is a function which can be used to select data that is not in a certain array. I currently have the following statement which is working correctly.

if {CustomerKey} in [7298, 7300, 7318, 758,759,760,761] then {QtyShipped}

What I now need is the opposite of this so it includes all Qty Shipped except for those in the range.

So basically I'm looking for the equivalent of the below statement.

if {CustomerKey} not in [7298, 7300, 7318, 758,759,760,761] then {QtyShipped}

Any help would be appreciated.

Thanks,

 

[synapsevampire]

SO close...:

if not({CustomerKey} in [7298, 7300, 7318, 758,759,760,761]) then {QtyShipped}

-k

 

[Parabolic33]

Thanks K, I appreciate it, worked like a charm :0)