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.

[#2]

Sorry expression incorrect I used.

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

[MWiciok]

Hi Gerhardus,

how do you get the Unit IW Thickness?

[#4]

=sum({<LITH.UNIT={"*IW"}>} LITH.THICKNESS)

[MWiciok]

Why don't you use

=min({$ <UNIT={'*IW'}>} THICKNESS)

to get the minimum?

[#6]

Using it chnaged the result from  0.123 to 0.05 and the lowest thickness is 0.15

=min({$ <LITH.UNIT={'*IW'}>} LITH.THICKNESS)

[MWiciok]

May be you could attach a QV file? I tried to rebuild your table and I got 0.15 as the Minimum...

[#8]

Thanks Matthias.

[MWiciok]

I just added listboxes so you can see the results:

The Expression =min({$<UNIT={'*IW'}>} THICKNESS) calculates the minimum thickness of possible "THICKNESS"-values, where the unit ends on IW. Is this what you want? Or do you want to let the user define which minimum to calculate by selecting the different parameters in the other fields?

[#10]

If i filter for

the textbox shows 0.05 and not 0.15