Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have one variable with set Analysis - and I have to make some selections for this value:
I tried it with the following Version (the yellow marked parts are the filters - but the values didn't changed:
if (ValueList('OpenOrders','BackOrders','Incoming Orders','NetSales') = 'OpenOrders',
num(((sum({<$(vClearCalendar),
ERDAT.LIPS = {">=$(=monthend(makedate(Year,$2,1)))"} ,
ABGRU.VBAP={"*"},
AUART.VBAK={"ZTA","ZWEB","ZMU","ZKL","ZIC"},
LFSTA.VBUP={"nicht bearbeitet","teilweise bearbeitet"}
>}OrderValue$(vCurrency).VBAP)
-
sum({<$(vClearCalendar),
ERDAT.LIPS = {">=$(=monthend(makedate(Year,$2,1)))"},
ABGRU.VBAP={"*"},
AUART.VBAK={"ZTA","ZWEB","ZMU","ZKL","ZIC"},
LFSTA.VBUP={"nicht bearbeitet","teilweise bearbeitet"}>} DeliveryValue$(vCurrency).LIPS))
+
sum({<$(vClearCalendar),beliefert.VBAP = {0}>}OrderValue$(vCurrency).VBAP))/$1,'#.##0'),
How do I have to include this filters?
Thank you a lot for your help!
Best regards,
Barbara
Those filters look right, what is the issue? They are not restricting your data? Would you be able to provide a sample where we can see them not working?
Thanks,
Sunny
What is the variable of vClearCalendar and vCurrency
And then remove the
num(((sum({<$(vClearCalendar) -- What is the use of (( here
- ANIL
No, they are not restricting the data...
Could it be, that it's hard-coded?
Thanks
Barbara
vClearCalendar is a variable which "deletes" the default-date. the previous day is set as Default date. But for this KPI this date is not needed...
vCurrency is for switching currency between Local currency and EUR
But this both variables are not important for this issue I think..
Thanks,
Regards,
Barbara
Would you be able to share a sample to look at?