2 Replies Latest reply: Aug 31, 2012 6:06 AM by Thomas Skariah RSS

    Simple set analysis question

      Hello all,

      I have a simple Set Analysis question. I just cant get it to work and im getting nuts   See the code below:

       

      This works!

       

      =sum
      (
          {
              $<
                  Year={$(=max(Year))},
                  [Year Month]={$(=num(max([Year Month])))}
              >
          }
      VALUE
      )
      

       

      This does not work!

       

      =sum(
      {
          $<
          Year=,
          [Year Month]={"$(=max([Year Month]-1))"}    
          >
      }
      VALUE
      )
      

      Im trying to compare a value with the value last month. Could anyone give me a suggestion for how to do this?

      The field [Year Month] has the value = "200101".

       

      Br

      c