Problem with Min() function in expression

[#1]

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.

[MWiciok · Accepted solution]

Now I got your problem: Thickness is a calculated Expression. See attached file and the second TextBox for your answer.

UPDATE: I forgot to use Set Expression to hard filter on *IW. So you have to add this if you want,

[#3]

Matthias, thanks for your patience.

It works perfect, i did not Aggr on the correct expresions originally.