Expression as Variable (in variable overview)

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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