expression sum and ?

[selcukcadir]

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

[jagan · Accepted solution]

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.