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

    Display Previous month scores

    Ayush KANSHAKAR

      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.