2 Replies Latest reply: May 18, 2012 9:31 AM by Abdur Razak Amod RSS

    Get specific value of field

      Hi,

       

      I am trying to get the description of a tjhe value associated with it:

       

      for the value I have this expression,

       

      Sum(Aggr(If([Sector] = 'Other Equity', MAX(MarketValue)),Sector)

       

      This gives me the value I need, Now I need the InstrumentDescription associated with this value,

       

      I tried using the ffg:

       

      =if(MarketValue=Sum(Aggr(If([Sector] = 'Other Equity', MAX(MarketValue)),Sector)),InstrumentDescription)

       

      But, unfortunately I do not get anything.

       

      Does anybody know a way of doing this...

       

      Kind Regards,

      Razak

        • Get specific value of field
          Jason Michaelides

          try:

           

          Only({<MarketValue={"=Sum(Aggr(If([Sector] = 'Other Equity', MAX(MarketValue)),Sector)"}>} InstrumentDescription)

           

          Hope this helps,

           

          Jason

            • Get specific value of field

              Hi,

               

              I got this to work:

               

              =

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

               

              This gives me the Highest value, but I also want the lowest value, But when I do this

               

              =

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

               

              i.e. change Max to Min to get the least value I get nothing just a dash(-).

               

              Can you please help me with this...

               

              Regards

              Razak