1 Reply Latest reply: Aug 20, 2014 11:06 AM by Kothandaram Mugalipoo RSS

    Set analysis, disregard selection

      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