Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Remove the = character from the expression in your variable. And use $(vONIB) instead of sum($(vONIB)) as chart expression.
Remove the = character from the expression in your variable. And use $(vONIB) instead of sum($(vONIB)) as chart expression.