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.

       

      example:

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

       

      but

      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,