Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
STATUS <> 0 and RECDATE <= Selected_Date
STATUS = "I" and RECDATE <= Selected_Date and INVDATE > Selected_Date
STATUS = "F" and RECDATE <= Selected_Date and INVDATE > Selected_Date
STATUS = "X" and RECDATE <= Selected_Date and INVDATE > Selected_Date
Please ask your question clearly with informative way if possible provide any sample data or file otherwise any community member not properly give answer to your question.
Regards,
Anand
You can either use this using IF statements or using set analysis in expressions.
1) If statements
sum(if(STATUS <> 0 and RECDATE <= Selected_Date,Sales))
2) Set analysis
sum({<STATUS-={0},RECDATE={"selectedate"}>}Sales) * RECDDATE and selecteddate must be in same format.
Thanks,
Singh
thanks
and what about invdate ?
LOAD
Status,
Stockid,
Model,
RECDATE,
INVDATE
FROM
(qvd) ;
My Customer want to show the Available Stock till the date selected.
with this Condition :
STATUS = "I" and RECDATE <= Selected_Date and INVDATE > Selected_Date
For example :
if i select ( march/2014),
i need to see : the stock available stock from 1900 til 31/03/2014.
and if a car received on 20/03/2014 and invoiced on 02/04/2014 -----> i have to show it.
but if a car received on 20/03/2014 and invoiced on 28/03/2014 -----> i dont want to show it.
try like:
count({<{STATUS={"I"},RECDATE = {"<=$(=max(SelectedDate))"} ,INVDATE = {">$(=max(SelectedDate))"}}>}Stockid)
If not clear than please attach a sample app.
Thanks,
Singh