6 Replies Latest reply: Dec 11, 2017 4:58 PM by Sunny Talwar RSS

    Rolling 12 Months Flag not working.

    nithin miryala

      Hi Everyone,


      I need to create a flag in the Data modal for Rolling 12 months with respect to Current Quarter start.


      So to test the expression i have wrote it in a list box and the logic feels correct to me and i connot figure what is wrong here,



      if(date(MonthYear)>=Addmonths(QuarterStart( Max(MonthYear)),-12) and date(MonthYear)<QuarterStart( Max(MonthYear)) ,1,0)


      According to expression all the Dates between 10/1/2016 and 10/1/2017 should be 1 and rest of them should be 0




      I have also attached the Test application.


      Please kindly let me know you thoughts.