2 Replies Latest reply: Nov 1, 2017 4:53 AM by Sunny Talwar RSS

    How to write a greater than expression

    naveen kumar

      Hello All,

               

                  I need to write a expression to display only those prices where count of distinct prices are greater than 1 for a materials and plants combination


      so i wrote this expression


      Aggr(If(Count({<SCOPE={'Yes'}, VALIDTO ={">$(=Date(today(),'DD-MM-YYYY'))"}>} DISTINCT PRICE_MAT) > 1, sum({<SCOPE={'Yes'}, VALIDTO ={">$(=Date(today(),'DD-MM-YYYY'))"}>}DISTINCT PRICE_MAT)),[MATERIAL CODE],[PLANT CODE])


      so what i got is this()

      Capture1.PNG

      The Above expression is picking only one supplier even though it is having 6 distinct supplier ,so what should i need to change in my expression to get display all the supplier for that material plant combination

      Capture.PNG

       

       

      Thanks