Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Try this
sum({$-1<Date ={">=1/11/2012<=30/11/2012"}, CustomerOrderTypeCode={"Voorverkoop"}>}OrderQtyOpen )
Niranjan.
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
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
Hello,
thank you for your reply, can you tell me what the "P" just does in your expression?
thanx!
chris
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
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
Hi,
you can use as well E instead of P for Excluded values
christian
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 )
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