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,

       

      Expression:

      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

       

      Capture.JPG

       

      I have also attached the Test application.

       

      Please kindly let me know you thoughts.

       

      Thanks

      Nithin