10 Replies Latest reply: Oct 19, 2016 6:49 AM by Sunny Talwar RSS

    Set Analysis for Prior Month

    Mohammad Sarif

      Hi All,

      I have field called sys_created_on. I have calculated Year Month on basis of this. Below is my expression:

      Date( MonthStart( sys_created_on ), 'YYYY-MM') as [Month_Year1]

       

      I extracted max Month using    set v2= max(Month_Year1);

       

      Now I want to see value for prior to max month. I have used below expression:

       

      Count({<Month_Year1 ={"=Date(addmonths($(v2), -2), 'YYYY-MM')"} >} number).

      But it is always showing current month data only. Not prior to max month.

       

      Please help.

       

      Thanks,

      Sarif