Select in field: How to use Search String?

[#1]

I have something which looks like the below at the moment:

http://imgur.com/tIz0SD3

In English I would like to select the field "c_Cinema" which has the minimum "d_DistanceApart_Miles"

c_Cinema is a string, d_DistanceApart_Miles is an int.

Data would look like so

Cinema 1    -    1 miles

Cinema 1   -     1.5 miles

Cinema 2   -     4 miles

Cinema 2    -   4.5 miles

etc...

Could anyone help me out?

[sushil353]

Please find the attached application:

=Only({<d_distance={$(=min({1}d_distance))}>} c_cinema)

HTH

Sushil

[er_mohit]

Try this

sum({<d_distance={"$(=min(d_distance))"}>} c_cinema)

or

only({<d_distance={"$(=min(d_distance))"}>} c_cinema)

[#4]

Hey this is close.

referring to my example again

Cinema 1    -    1 miles

Cinema 1   -     1.5 miles

Cinema 2   -     4 miles

Cinema 2    -   4.5 miles

This seems to be returning me

Cinema 1 - 1 miles

How can I make sure I include all cinemas in the current selection?

e.g. return

Cinema 1 - 1 miles

Cinema 2 - 4 miles?

[er_mohit]

Try this

sum({1<d_distance={"$(=min(d_distance))"}>} c_cinema)

or

only({1<d_distance={"$(=min(d_distance))"}>} c_cinema)

or this

sum({1<d_distance={"$(=min({1}d_distance))"}>} c_cinema)

or

only({1<d_distance={"$(=min({1}d_distance))"}>} c_cinema)