15 Replies Latest reply: Aug 11, 2017 9:22 AM by Sunny Talwar RSS

    number of parts with multiple prices with same supplier

    naveen kumar

      Hi All,

              the KIP i need to show is

                            # parts with multiple prices with same supplier 

      what i understand is , i need to show number of materials  which is supplied by same supplier having more then one distinct  price and validto has to be greater than today()


      Dimension :Supplier

      Expression:

      aggr(Count({<SCOPE={'Yes'},VALIDTO={">$(=Date(today(),'DD-MM-YYYY'))"},supplier={"=Count(Distinct Price)>1"}>}distinct part),supplier)


      i am getting materials , suppliers which has only one  price ,which should not ,so i think  the greater than syntax in my expression

      has problem,

       

       

       

       

      any  suggestion plz..

       

       

      Thanks