8 Replies Latest reply: May 22, 2012 3:33 AM by Abdur Razak Amod RSS

    Positive value works, but not negative values does not work in set analysis

    Abdur Razak Amod



      I have the following expression, it gives me the description of the Instrument with the highest Marketvalue,which works fine:



      Minstring({< MarketValue = {$(=Num(Max({<[Sector] = {'Equity'}>} MarketValue)))} >} [InstrumentDescription])


      However, when I try this to get the Instrument with the lowest MarketValue I get nothing returned, Iuse the below expression.



      Minstring({< MarketValue = {$(=Num(Min({<[Sector] = {'Equity'}>} MarketValue)))} >} [InstrumentDescription])   


      Any help is appreciated....