7 Replies Latest reply: Nov 4, 2013 8:49 AM by Fredrik Wikberg RSS

    Syntax for Set Analysis comparing Last Year to Date

    Fredrik Wikberg

      Hi All

       

      I am trying to make a Set Analysis comparing sales for Last Year to Date. I have created a variable that show the date for last year. This variable is called vLYTD.

       

      This variable is 2012-11-04 today when using the date() function otherwise 41217.

       

      I am trying to make a set analysis for this variable but cant get the syntaxt to work. I think this has to do with the formating. At the moment I have written the line as following.

       

      sum({$<Year={$(#vLastYear)},Datum={"<=$(#vLYTD)"}>}Budget),

       

      Where Datum should only make the summation for all records up to 2012-11-04.

       

      Any help in solving this is appreciated.