3 Replies Latest reply: Jul 4, 2017 9:52 AM by Vineeth Pujari RSS

    what wrong with my expresssion

    naveen kumar

      Hello,

                i am trying to display Single material supplied by multiple vendor

       

      Dimensions: Material , Vendor Name ,Vendor Code

       

      expressions i tried  are :

      1)Spend:

      Num(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},Material={"=Count(Distinct [VENDOR CODE])>1"}>}Spend)/100,'#,##0 ')

                                                             or


      If(Count(distinct TOTAL <Material> [VENDOR CODE])>1,Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'}>}SPEND))


      2)Quantity:


      Num(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},Material={"=Count(Distinct [VENDOR CODE])>1"}>}VOLUME)/100,'#,##0 ')


      But  the expressions not giving me correct o/p

      Capture.PNG

      even though the vendor name and vendor code are same but they are two different materials ,they should be considered when i am showing Multi sourced  vendors  because each material as only one supplier..



      can any one help in this plz