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!
Try all the RZZLOKKT values quoted with single quote or double quote
Maeby you need to add the = symbol inside modifier RYEAR ? This is if Anul contains a function..
RYEAR = {$(=Anul)}
I guess the issue might lie in 'RYEAR = {$(Anul)}'. If 'Anul' is a variable, try like:
RYEAR = {"=$(=Anul)"}
Try this
RYEAR = {'$(Anul)'}
Thank you, guys! Sorry! I don't know why but it's not working ( And I've tried all your solutions.
Could you share sample app?
Try to create a flag into LOAD script (IF Statement), so use:
SUM ({<RZZLOKKT = {'Y'}, RBUSA ={'BOO'}, RBUKRS={'ASIN'}, RYEAR = {'=$(Anul)'} >} HSL123)
TRY:
SUM ({<RZZLOKKT ={'5001106470','5099001000','5099004000','5099006000','5099014000','50990'50000','5099053000','5099054000','509905'5000','5099056000','5099057000','5099058000','5099059000',
'5099060000','5099102000','5099110000','5099111000','5099149000','50991'50000','5099151000','5099153000','5099154000','5099157000','509952'5000','5099200000','5099201000',
'5099203000','5099210000','5099211000','5099212000','5099213000','5099214000','509921'5000','5099251000','5099252000','5099253000','5099254000','5099269000','5099288000',
'509939'5000','5099536000','5099301000','5099302000','5099304000','509930'5000','5099311000','5099312000','5099313000','5099314000','5099318000','5099343000','5099349000',
'5099356000','5099409000','5099351000','5099220000','50993'50000','509935'5000','5099360000','5099398000','509945'5000','5099354000','5099364000','5099380000','5099382000',
'5099383000','5099384000','5099386000','5099399000','509940'5000','5099449000','5099352000','5099391000','5099392000','5099410000','509900'5000','5099367000','5099422000',
'50994'50000','5099451000','5099452000','5099453000','5099454000','5099492000','5099361000','5099402000','5099522000','5099523000','5099529000','5099368000','5099420000',
'509944'5000','5001106400','5099001000','5099004000','5099006000','5099014000','509901'5000','50990'50000','5099053000','5099054000','509905'5000','5099056000','5099057000',
'5099058000','5099059000','5099060000','5099102000','5099110000','5099111000','5099149000','50991'50000','5099151000','5099153000','5099154000','5099157000','509952'5000',
'5099200000','5099201000','5099203000','5099210000','5099211000','5099212000','5099213000','5099214000','509921'5000','5099251000','5099252000','5099253000','5099254000',
'5099269000','5099288000','509939'5000','5099536000','5099301000','5099302000','5099304000','509930'5000','5099311000','5099312000','5099313000','5099314000','5099318000',
'5099343000','5099349000','5099356000','5099409000','5099351000','5099220000','50993'50000','509935'5000','5099360000','5099398000','509945'5000','5099354000','5099364000',
'5099380000','5099382000','5099382100','5099383000','5099384000','5099386000','5099399000','509940'5000','5099449000','5099352000','5099391000','5099392000','5099410000',
'509900'5000','5099367000','5099422000','50994'50000','5099451000','5099452000','5099453000','5099454000','5099492000','5099361000','5099402000','5099522000','5099523000',
'5099529000','5099368000','5099420000','509944'5000}, RBUSA ={'BOO'}, RBUKRS={'ASIN'}, RYEAR = {'$(Anul)'} >} HSL123)
or post sample app..
Regards,
Hi, try this!!
What are you doing in your variable, in my example just select a year
the examples of set analisys is on the text object
i shared the example !!
Regards.