FInd minimum value based on condition

[siweltj]

I am attempting to identify the minimum value in EvOrder where Activity = 0. In the example below this would be EVOrder=20833353.

The order and sequence of these values are dynamic and will change in order.

The result of this value will tie into additional formulas for later use.

Any thoughts?

EvOrder Activity
1 4
20833353 0
23958339 1
37516362 0
42191591 1
43750013 7
46332971 5
47193953 0
48341956 0
48536767 1
48601729 1
50148381 0
50728458 1
50767064 0
50773725 0
55380246 0
56919850 1
57433028 1
57717670 1
57812540 5
68359376 6
99999999 3

 

[lbass]

Create a formula like this:

if {table.activity} = 0 then
{table.EvOrder} else
tonumber({@null}) //remove tonumber if EvOrder is not a number

...where {@null} is a new formula that you open and save without entering anything.

Then insert a minimum on this formula.

-LB