11 Replies Latest reply: Nov 29, 2017 9:23 AM by Shraddha Gajare RSS

    Expression partially working

    naveen kumar

      Hello All,

                      Some thing weird is happening with me, expression is working on one row and not working on another row

       

      I am trying to get minimum NUMBER's  Volume ,the expression I wrote is below

        Expression:

                      

        sum({<SCOPE={'YES'},NUMBER={"$(=Num(min(NUMBER),'000'))"}>}total<[MATERIAL CODE],[VENDOR CODE]>VOLUME)

      Capture.PNG


      what I suppose to get is for

                                                    0002 and 098C              733114 is min volume(I am getting )

      for                                          40B  and  061                    473 is min volume (Getting Null)

       

      what am I missing in my expression


      Thanks