I have a list with numbers in.I need to keep the row with the first positive number (also the smallest) in .
How??,
grts
min([data item]) > 0
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
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.
Thanx, it is working with a subquery (the only thing to do is to set the properties of the variables ==> aggregate none)
johangel