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

    Problem with Min() function in expression


      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))