36 Replies Latest reply: Feb 6, 2015 6:52 AM by Sunny Talwar RSS

    Chart Caluclation

      Hi Every one,


      I have 5 asset classes in my chart and periods are P0 to P1, out of 5 asset classes 1 is OTC Derivative, when I make selection of OTC and Period=P0 values should be added to other periods(P1 to P15) and you can find current chart and it should be change to my requirement.

      Make sure that this change should not reflect to other selections.


      Current expression is: if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))


      Thanks for your help in advance.