Multiple Field Selection in Set Analysis

[#1]

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

[sunny_talwar]

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

[Anil_Babu_Samineni]

What is the variable of  vClearCalendar and vCurrency

And then remove the

num(((sum({<$(vClearCalendar) -- What is the use of (( here

- ANIL

[#4]

No, they are not restricting the data...

Could it be, that it's hard-coded?

Thanks

Barbara

[#5]

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

[sunny_talwar]

Would you be able to share a sample to look at?