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

    Set Expression with Variable minus one

    Fredrik Wikberg

      Hi

       

      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.

       

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

       

      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.

       

      //Fredrik