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.

       

      guage.PNG

       

       

      Thanks in advance!