first positive number

[johangel]

I have a list with numbers in.I need to keep the row with the first positive number (also the smallest)  in .
How??,
grts

[RKMI]

min([data item]) > 0

[johangel]

it is not working, probably because the row is a result of a "running count" function....
I have next example:
difference between 2running counts
-95
-83
-57
-20
13
19
I need the row with the first positive number? (the row with 13....)
johan

[RKMI]

Can you try specifying the solve order to do the running counts first and after do the min function? (or) you even make a subquery do the running count in one query and in the subquery specify the min ()>0 just another approach avoiding to specify all solve order.

[johangel]

Thanx, it is working with a subquery (the only thing to do is to set the properties of the variables ==> aggregate none)
johangel