Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to get the minimum number but greater than ZERO.
how to do it using expression?
=Min(min(x)>0)
Try:
=Min({<x={'>0'}>} x)
May be try this too
=min ({<X > 0 >} X)
or
min ({<X -= {'0'}>} X)
May be this..
Min({<x={">0"}>} x)
or this too
Min({1<X={">0"}>} X)
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?
Hi Hussain,
You can try as follows,
Min(if(X>0,X))
I'm not getting the right value from the above
Would you mind sharing more details? What do you have and what are you looking to get?