2 Replies Latest reply: Aug 2, 2018 11:03 AM by Andrea Gigliotti RSS

    Comparing variable to Month in expression

    Kumar Kush

      Hi Guys,

       

      I'm trying to use set analysis to calculate M2D & Y2D values for some measure which should remain constant irrespective of other selections.

      I'm storing the current Month, Year in separate variables defined as vYear = Year(Today()).

      I have a separate field from my database which is called 'Year'.

       

      Now, my set analysis expression looks like :

      Sum({1<[Year]={'$(vYear)'}>}OOS)

       

      However, this returns no results whereas if I output the values through KPI indicators, they both say '2018'.

      If I change my variable from the function to just '2018', this works fine.

      My first thought is that there is a datatype mismatch - which I have no idea how to handle in QS.

       

      Would you be able to point what the issue is?