3 Replies Latest reply: Dec 21, 2017 7:40 AM by Felip Drechsler RSS

    Dynamic selection

    Kshitija Shinde

      Hello Community,


      I want to get sum of amount for current selection of year and then subtract value of its previous year from that.

      Below expression works in static manner, i want it to work dynamically based on selection of years.


      ((((sum({<Reference={'1','2','3'},[FY Year Name]={'2017-18'} >}Amount))-

      (sum({<Reference={'1','2','3'} ,[FY Year Name]={'2016-17'}>}Amount)))/(sum({<Reference={'1','2','3'} ,

      [FY Year Name]={'2016-17'}>}Amount))))


      This is the result of the above expression, but i want it to change based on selection in year filter.





      Thanks in advance!