explorations filter

[JulesH]

How can i filter only 1 security out of a list of them ?
The filter has to select the security with the maximum number in a colomn which is the result of a calculation or formula.
Since the absolute value of this calculation is variable in time the functions > are not suitable.

Jules

 

[JohnD]

I'm not sure how to do precisely what you ask for, but you can get the answer you want by simply not using a filter and, in the reports listing clicking on the column containing the value you require, which will cause that column to be sorted, so you can easily see which is the entry with the highest or lowest value.

John

How can i filter only 1 security out of a list of them ?
The filter has to select the security with the maximum number in a colomn which is the result of a calculation or formula.
Since the absolute value of this calculation is variable in time the functions > are not suitable.

Jules