6 Replies Latest reply: Oct 15, 2012 12:22 PM by facundo de la cal

# Minimum value.

Hi All,

i have a table in which a field Type which conatains two type of value X and y and in another column there is many numeric values but i want only latest and minimum values.

table is like

XandY, VALUE

X,12754

X,12721

X,12719

Y,4073

Y,4072

Y,3907

I want the X minimum value X-12719 and Y-3907

Thanks

• ###### Re: Minimum value.

SEE IF IT IS WAHT YOU NEED

• ###### Re: Minimum value.

Hi,

Use the TOTAL qualifier within the expressions

```Min(TOTAL <XandY> VALUE)
```

Hope that helps.

Miguel

• ###### Re: Minimum value.

Thanks Both but i want two min values let me explain the table first it is some thing like

XandY, E, S, E-S

X, 123192, 110438, 12754

X, 123192, 110471, 12721

X, 123192, 110473, 12719

Y, 33167,  29094, 4073

Y, 33167,  29095, 4072

Y, 33167,  29260, 3907

In a straight table or pivot table it is look like this

i want to highlight or otherwise take the minimum values of XandY in the text box to show the minimum values like

X-12719

Y-3907

Thanks

• ###### Re: Minimum value.

You can try this expression.

Min({<XandY = {"X"}>}VALUE)

Only change X to Y for getting minimum value of Y.

Regards,

Kaushik Solanki