9 Replies Latest reply on Sep 20, 2018 8:31 AM by Ayush KANSHAKAR

    Display Previous month scores


      Hi All,


      I am trying to display the previous month date in the workbook. For instance, if the current month is September, I want to display the scores for August and in next month (October) it should display September scores. The start date should be constant i.e January 2018.

      I used this calculation:

      DATEADD('month',-1,[Date_Full (Custom SQL Query)] )


      This calculation displayed the previous month date i.e August but the score are from the current month i.e September. It also changed the start date to December 2017.


      1. Before using Calculation


      2. After using calculation



      Thank you in advance for your help.