Set Analysis- Multiple Conditions

[#1]

Hi guys,

I need a little bit of help, so I hope to get it from you.

I have a data table from SAP and I'm trying to define some expressions based on that table. I am using set analysis, but I don't know why is not working. I must say that I have a lot of conditions.

My expresion looks like this

SUM ({<RZZLOKKT ={5001106470,5099001000,5099004000,5099006000,5099014000,5099050000,5099053000,5099054000,5099055000,5099056000,5099057000,5099058000,5099059000,

5099060000,5099102000,5099110000,5099111000,5099149000,5099150000,5099151000,5099153000,5099154000,5099157000,5099525000,5099200000,5099201000,

5099203000,5099210000,5099211000,5099212000,5099213000,5099214000,5099215000,5099251000,5099252000,5099253000,5099254000,5099269000,5099288000,

5099395000,5099536000,5099301000,5099302000,5099304000,5099305000,5099311000,5099312000,5099313000,5099314000,5099318000,5099343000,5099349000,

5099356000,5099409000,5099351000,5099220000,5099350000,5099355000,5099360000,5099398000,5099455000,5099354000,5099364000,5099380000,5099382000,

5099383000,5099384000,5099386000,5099399000,5099405000,5099449000,5099352000,5099391000,5099392000,5099410000,5099005000,5099367000,5099422000,

5099450000,5099451000,5099452000,5099453000,5099454000,5099492000,5099361000,5099402000,5099522000,5099523000,5099529000,5099368000,5099420000,

5099445000,5001106400,5099001000,5099004000,5099006000,5099014000,5099015000,5099050000,5099053000,5099054000,5099055000,5099056000,5099057000,

5099058000,5099059000,5099060000,5099102000,5099110000,5099111000,5099149000,5099150000,5099151000,5099153000,5099154000,5099157000,5099525000,

5099200000,5099201000,5099203000,5099210000,5099211000,5099212000,5099213000,5099214000,5099215000,5099251000,5099252000,5099253000,5099254000,

5099269000,5099288000,5099395000,5099536000,5099301000,5099302000,5099304000,5099305000,5099311000,5099312000,5099313000,5099314000,5099318000,

5099343000,5099349000,5099356000,5099409000,5099351000,5099220000,5099350000,5099355000,5099360000,5099398000,5099455000,5099354000,5099364000,

5099380000,5099382000,5099382100,5099383000,5099384000,5099386000,5099399000,5099405000,5099449000,5099352000,5099391000,5099392000,5099410000,

5099005000,5099367000,5099422000,5099450000,5099451000,5099452000,5099453000,5099454000,5099492000,5099361000,5099402000,5099522000,5099523000,

5099529000,5099368000,5099420000,5099445000}, RBUSA ={'BOO'}, RBUKRS={'ASIN'}, RYEAR = {$(Anul)} >} HSL123)

I just can't realize where is my mistake. If I try to do the expresion with IF and OR it's working just for few records.

Thank you!

[#2]

Good morning!

Here's a sample of what I am trying to do. Hope that helps.

Thank you!

Regards!

[tresesco]

Couple of issues i noticed in your sample app:

-variable('Anul') definition was hard coded and value was derived - 2013, and there was no data for that year.

-you were summing HSL123, which should be HSL

-there was no data for those codes (RZZLOKKT) I added one(the first one) to test

Finally, with right data the expression should work as in attached sample.

[#4]

Thank you all very much! I finally saw where was the problem and solved it.

Best Regards!