Skip to Content
Apr 20, 2007 at 10:09 PM

Bottom N based on added table column



In my iView, I have a table that uses an expression box that calculates the distance based on the locations from this table and, from a location stored on a separate form. I can calculate the distances correctly, but I would like to display only the 10 closest locations. The locations that are generated in the table are coming from a BI query.

I don't believe I can use the "LOWER" operator, because this is placed between the BI query and the output table since the query itself does not contain the distance data. Is there a way to do this? Any help would be appreciated. Thanks.