Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have something which looks like the below at the moment:
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?
Please find the attached application:
=Only({<d_distance={$(=min({1}d_distance))}>} c_cinema)
HTH
Sushil
Try this
sum({<d_distance={"$(=min(d_distance))"}>} c_cinema)
or
only({<d_distance={"$(=min(d_distance))"}>} c_cinema)
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?
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)