1 Reply Latest reply: Jul 5, 2017 5:14 AM by Peter Rieper RSS

    multi sourced material 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

      Expression i tried :


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


      All the 100% rows are  single vendor supplied material


      so how to not display this 100% rows