15 Replies Latest reply: Jul 5, 2017 5:40 AM by kushal chawda RSS

    how to write expression

    naveen kumar

      Hello All,

                       i am able to achieve my requirement  partially . the thing is i am trying to display only those materials,spend which has supplied by multiple vendors

      Expressions i tried :

       

      1)Sum({<SCOPE={'Yes'},Material={"=Count(Distinct [VENDOR CODE)>1"}>}SPEND)

       

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


      but both the expressions are giving me list of  multiple vendors and single vendors materials , as below


      Capture.PNG

      All the 100% rows are  single vendor supplied material

       

      so how to not display this 100% rows

      Any suggestion plz.....