2 Replies Latest reply: May 24, 2016 8:36 AM by Ziad Salem RSS

    Set Analysis with a Variable

    Ziad Salem

      Hello,

       

      I am using the following set analysis and it fails to return the data.

      =Only({1<Month={"$(vMonthNr)"}>} Minutes)

      Where: vMonthNr = Month('$(vFromDate)')

       

      I have tried to use a variable which has fixed value. in this case, It works perfectly. please see the expression bellow.

       

      =Only({1<Month={"$(vMonth)"}>} Minutes)

      where vMonth = 4

       

      The variable "vFromDate" takes its value from a calendar extension. and the field Minutes comes from this Data.

      [Table1]:

      LOAD * inline ["Month", "Minutes"

              1, 12000,

               2, 12600,

               3, 12600,

               4, 12600,

               5, 12000,

               6, 13200,

               7, 12600,

               8, 13800,

               9, 13200,

               10, 12000,

               11, 13200,

               12, 12600,];

       

      When the variable has a plain value it works but when the variable has an expression it does not works.

       

      Thanks in advance.