Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a date selection in my UI. - it'a REF_DATE in my qv table
There is also a chart where I do sum(amount) in my expression.
I need another expression, which has logic
sum(if REF_DATE <= selected REF_DATE, amount, 0)
so, when I select 1 July 2014 i need to get accumulated amount until selected day.
I tried something like this, but it doesn't work. Somehow I need to eliminate current selection
=Sum({<REF_DATE={"<=$(= max(REF_DATE))"}>} amount)
Can you please help me
Thanks
Can you try like this
=Sum({1<REF_DATE={"<=$(= max(REF_DATE))"}>} amount)
Can you try like this
=Sum({1<REF_DATE={"<=$(= max(REF_DATE))"}>} amount)