5 Replies Latest reply: Oct 2, 2013 10:41 AM by Fredrik Wikberg RSS

    Set Expression with Variable minus one

    Fredrik Wikberg



      I am trying to create a set analysis for an expression that have a variable that I want to take minus 1 with.


      I have the following expression in a bar chart that works fine.


      =Sum({<Date.Year={$(vCurrentYear)},Date.WeekNum=>} InvoiceTrans.Quantity)


      I want to add a line chart to the same chart with the sum for CurrentYear minus 1.


      I have written this expression.




      This does not work due to the connotation in the set expression for year -1.


      I couldnt find any helpful info at the website. So I wonder if anyone knows how this set expression should be writte to display data for the graph?


      Thanks for any help.