Min >0

[kevbrown]

Hi

I have a rang of number, some negative some positive and I want to pull out the smallest which is greater than Zero

so

Field

-50

-20

-5

2

5

8

50

I want to pull out 2 from my data, I've tried =min ({<Field > 0 >} Field) but it doesn't like it

[swuehl]

Try

=min ({<Field = {">0"} >} Field)

[tresesco · Accepted solution]

Try like:

min ({<Field ={'>0'} >} Field)

[Kushal_Chawda]

min(if(Field>0,Field))

[balabhaskarqlik]

Try like this:

=Min(If(Field>0,Field))

[ils4nt0]

this works! you male my day!