Expression as Variable (in variable overview)

Thu, 07 May 2015 12:07:35 GMT

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

Any ideas?

Regards,

Olle

Re: Expression as Variable (in variable overview)

Gysbert_Wassenaar — Thu, 07 May 2015 13:17:18 GMT

Remove the = character from the expression in your variable. And use $(vONIB) instead of sum($(vONIB)) as chart expression.