Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
//Sum ({$<SAP_ANAGRUP={"JELLY"}>} MIKTAR) >>>> working
I want to do ,
if ( SAP_ANAGRUP="JELLY" and mid(MALZEME_NO,11,2) ="16" and ISTUR2 = "WR" and (ISTUR = "101" OR ISTUR = "102"), MIKTAR )
but it does not work
sum (
{$<
SAP_ANAGRUP={"JELLY"},
mid(MALZEME_NO,11,2) ={"16"},
ISTUR2 = {"WR"},
(ISTUR = {"101"} OR ISTUR = {"102"}),
>}
MIKTAR
)
picture Added
Hi,
You create another field in your script for MALZEME_NO by using the
mid(MALZEME_NO,11,2) as Dimension1
Now try expression below. If you calculate in load script the performance would be better.
sum (
{$<
SAP_ANAGRUP={"JELLY"},
Dimension1 ={"16"},
ISTUR2 = {"WR"},
ISTUR = {"101, 102"} >}
MIKTAR
)
Hope this helps you.
Regards,
jagan.
Hi,
You create another field in your script for MALZEME_NO by using the
mid(MALZEME_NO,11,2) as Dimension1
Now try expression below. If you calculate in load script the performance would be better.
sum (
{$<
SAP_ANAGRUP={"JELLY"},
Dimension1 ={"16"},
ISTUR2 = {"WR"},
ISTUR = {"101, 102"} >}
MIKTAR
)
Hope this helps you.
Regards,
jagan.