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

[#2]

Hi,

Try this

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

Niranjan.

[nirav_bhimani]

HI,

The data you want to exclude use - sign before = sign of that field.

eg.

In your case I am excluded CustomerOrderTypeCode with - sign.

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

Regards,

Nirav Bhimani

[chriscools]

Hey,

will this help to exclude only the orderqtyopen from "Voorverkoop" between the two dates?

all the orderqtyopen with an customerordertypeCode different from Voorverkoop can be shown.

for example

date = 15/11/2012

customerOrderType= CashAndCarry

in this case orderqtyopen must be taken into account.

grtz,

chris

[chriscools]

Hello,

thank you for your reply, can you tell me what the "P" just does in your expression?

thanx!

chris

[nirav_bhimani]

Hi,

P Representing the element set of possible values of a filed.

Have you got your ans? If  set analysis ans is helpful then tick as helpful ans or correct ans.

Regards,

Nirav Bhimani

[chriscools]

Hello,

thanx for the explanation!

i'm not sure that your proposal also includes this:

for example

date = 15/11/2012

customerOrderType= CashAndCarry

in this case orderqtyopen must be taken into account.

grtz,

chris

[#8]

Hi,

you can use as well  E instead of P  for Excluded values 

christian

[chriscools]

Thanx,

and how would i then need to paste it into this, just to exclude the values from "Voorverkoop" between 1/11/2012 and 30/11/2012, and everything else must be shown?

thanx!

chris

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

[nirav_bhimani]

Hi,

Sorry I didnt get your question.

CustomerOrderType and CustomerOrderTypeCode both are diff ????

Now you want to consider customerOrderType="CashAndCarry" as a part of expression, is it so?

Regards,

Nirav Bhimani