Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=min ({<Field = {">0"} >} Field)
Try like:
min ({<Field ={'>0'} >} Field)
min(if(Field>0,Field))
Try like this:
=Min(If(Field>0,Field))
this works! you male my day!