2 Replies Latest reply: Feb 16, 2018 3:19 AM by rohan chavan RSS

    Last month vs Current Month till Date Comparison

    rohan chavan

      hi ,

            I have a requirement where i need to figure out comparison of current month sales to last month sales till date.

      For example if suppose today is 15/02/2018 then the current month sales will be till 15/02/2018 and in comparison column of last month the data will be from 01/01/2018 till 15/01/2018 . But by the following set expression i am getting the entier month data for Jan 2018 .

       

      Set expression for last month :-

      Count({<Year={$(=max(Year))},Month={$(=month(addmonths((Max(Date)),-1)))}>}Key)