Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Good morning!
Here's a sample of what I am trying to do. Hope that helps.
Thank you!
Regards!
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.
Thank you all very much! I finally saw where was the problem and solved it.
Best Regards!