5 Replies Latest reply: Sep 7, 2015 6:27 AM by Sebastian Keitel RSS

    Set analysis monthly trend

    Sebastian Keitel

      Hi All,

       

      I have a question regarding set analysis. I use this formula to get the revenue for the current or selected fiscal date:

       

      sum({<[Fiscal Date]={'>=$(=MonthStart(Max([Fiscal Date]), ))<=$(=MonthEnd(Max([Fiscal Date])))'}>} [Revenue])

       

      My formula to get the revenue for the month before is this:

       

      sum({<[Fiscal Date]={'>=$(=MonthStart(Max([Fiscal Date]), -1))<=$(=MonthEnd(Max([Fiscal Date])-1))'}>} [Recurring Revenue (Euro)])

       

      It works very well but once I selected more than one date in fiscal date (e.g. Oct 2014 and Nov 2014) I don´t get the correct value for the month before my selected date (in this case Sep 2014).

       

      Has anyone a solution?

       

      Thanks.