4 Replies Latest reply: Dec 22, 2011 11:26 AM by Pierre Philippon RSS

    Set Analysis: two selections

      Hello all

       

      I have a set of data With DateAdminFX, FXIDAdmin, FXPriceAdmin


      In a table, I have as a Dimension FXID (which comes from an other set of data), and one Date field called DateD is selected. As an expression in that table, I would like to get FXPriceAdmin where DateAdminFX=DateD (selection) and FXIDAdmin=FXID (the dimension).

       

      I tried =Sum({$<DateAdminFX=DateD,FXIDAdmin=FXID>} FXPriceAdmin) but without luck.

      These set analysis drive me crazy, where can we learn more about it? The reference manual is not helping me a lot...

       

      Many thanks