6 Replies Latest reply: Jun 23, 2014 4:07 PM by Jeremiah Kurpat RSS

    Using a variable in set analysis

      I have set a Current Month variable:

       

      vCurrentMonth= Month(Today(2));

       

      Which works in a text object, it shows "Jun" which is what I am looking for.

       

      The expression I use the variable in is as follows:

       

      =Count( {$< EndMonth =  { '$(vCurrentMonth)' } >} [Assignment ID] )

       

      Which results in zeros. But if I type Jun in place of the variable I get the correct data.

       

      I've tried:

       

      =Count( {$< EndMonth = { '=$(vCurrentMonth)' } >} [Assignment ID] )        Shows all data as if there was no set analysis

      =Count( {$< EndMonth = { ='$(vCurrentMonth)' } >} [Assignment ID] )        null values

      =Count( {$< EndMonth = { $('vCurrentMonth') } >} [Assignment ID] )          null values

      =Count( {$< EndMonth = { "$(vCurrentMonth)" } >} [Assignment ID] )         null values


      I'm all out of ideas for why this isn't working. Can anyone see a mistake in the syntax or have any insight for why this variable is not working.


      Thanks,