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

      Hi,

       

      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....

       

      Regards

      Razak