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.




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


      Any help in solving this is appreciated.