how to exclude a period and part of another field in set analysis?

[chriscools]

Hello,

i have an expression to give me qty still to deliver from a certain ordertype code taken between 2 dates.

How do i need to change the formula, to give me everything that is still open, EXCEPT everything from "Voorverkoop" between the two dates?

this is the formula:

sum ({<Date ={">=1/11/2012<=30/11/2012"}, CustomerOrderTypeCode={"Voorverkoop"}>}OrderQtyOpen )

can someone give me an idea?

thanx!

chris

[chriscools]

Hello,

i'm sorry about being messy in my explanation... 🙂

there is no difference between the 2 fields, the fiels is only CustomerOrderTypeCode.

i do not especially want to include "cashAndCArry" as a part of my expression.

what i'm looking for is the expression to exclude only the values of OrderQtyOpen

where only the values with customerordertypecode= "Voorverkoop" and where the date falls between 1/11/2012 and 30/11/2012 are excluded.

all values with "Voorverkoop" but a date outside of 1/11/2012 and 30/11/2012 must still be included.

and all values where CustomerOrderTypeCode is different from "Voorverkoop" must be included (here the date is not important!

grtz,

chris

[#3]

Hi,

sum({$-1<Date ={">=1/11/2012<=30/11/2012"}, CustomerOrderTypeCode={"Voorverkoop"}>}OrderQtyOpen )

try this, hope it will satiesfy all your requiremnt.

[chriscools]

Hello,

when i search for a specific article i normally i get only 1 line:

when i include the "$-1" like in your proposal i get (without changing the selection ) 2 lines:

why could this be?

chris

[chriscools · Accepted solution]

Hello,

i solved it like this:

sum ({< WarehouseName = {'WHS BE','Kontich'}, LocationFunction={'PICKING','BULK'}>} StockQty )

thank you all for your help and also Mr Wassenaar!

grtz,

chris