1 Reply Latest reply: May 7, 2015 9:17 AM by Gysbert Wassenaar RSS

    Expression as Variable (in variable overview)

      Hi,

       

      Im trying to store the below expression into a variable, but the value of the variable only shows the total value for all dates.

      How do I make it show the correct value for each date? Expected result in the red marked column.

      In the other column I've put SUM($(vONIB))

       

       

      SUM({<[FLOW TYPE]= {'O/N IB'}>} IF([FLOW EFFECTIVE DATE]<=DATE and [FLOW MATURITY DATE]>= DATE,AMOUNT))

       

      Capture.JPG

      Any ideas?

       

      Regards,

      Olle