Min() Function

[#1]

I would like to get the minimum number but greater than ZERO.

how to do it using expression?

=Min(min(x)>0)

[tresesco]

Try:

=Min({<x={'>0'}>} x)

[Chanty4u]

May be try this too

=min ({<X > 0 >} X)

or

min ({<X -= {'0'}>} X)

[surendraj]

May be this..

Min({<x={">0"}>} x)

[Chanty4u]

or this too

Min({1<X={">0"}>} X)

[sunny_talwar]

You have got some good answers above, but in case they don't provide what you wanted, would you be able to elaborate on what exactly are you looking to get with an example and desired output?

[Anonymous]

Hi Hussain,

You can try as follows,

Min(if(X>0,X))

[#8]

I'm not getting the right value from the above

[sunny_talwar]

Would you mind sharing more details? What do you have and what are you looking to get?