11 Replies Latest reply: May 26, 2014 9:37 AM by Gerhardus de Villiers RSS

    Problem with Min() function in expression

      Capture.PNG.png

      From the above table I sum data on the UG1 layer with total thickness, total Unit thickness and Min thickness where UNIT ends with IW.

       

      results should be:

      Thickness          Unit IW Thickness          Minimum IW thickness

           1.27                             0.5                                0.15      

       

      Minimum IW thickness not correct as I get is 0.123

       

      my expression is

      =(total  aggr(avg({<LITH.UNIT={"*IW"}>} LITH.THICKNESS),LITH.PACKAGE))

       

      Thanks.