2 Replies Latest reply: Jan 28, 2016 3:20 AM by Shiva Kumar RSS

    Using variable in Set Analysis

    Ciro ORIC

      Hi there!

      I'm trying to use set analysis in a kpi formula.


      I define the following variables:


      vYear2015 = 2015

      vLastYear  = Max(Year) - 1


      When I use vYear2015, my formula returns the correct value, but when I use vLastYear don't.



      Sum({1 <Year = { '$(vYear2015)' }>}  [Value])   => works



      Sum({1 <Year = { '$(vLastYear)' }>}  [Value])   => does't work (returns 0)


      I tried to use vLastYear at the kpi label and it works nice. (return 2015)


      What I'm doing wrong?


      Best regards,