1 Reply Latest reply on Jun 11, 2018 6:13 PM by Shinichiro Murakami

    How to extract the data by defining a certain date

    Helen Wang

      Dear all,

       

      I need to extract the Quarter To Date (QTD) Sell through Dollars. I have written one command and it worked: It can successful drag data for QTD 2018.

       

       

      Code:

      ZN(IF [Time-Curr Fis QTR]="Yes"

      THEN

      [Sell Thru Dollars]

      END)

       

      But when I want to do QTD for a more detailed level: 2017 Q1,

       

       

      Code:

      ZN(IF [Time-Curr & Prev Year (QTR)] = 'Yes' AND [Time-Prev Fis Year] = 'Yes' AND str(DATEPART('year',[Fiscal Year] ))= '2017' AND str(DATEPART('quarter',[Fiscal Quarter] )) ='1'

      THEN [Sell Thru Dollars]

      END)

       

      Is it because the way I index the data is not correct?

       

      I cannot give out data, i am sorry. I just want some advice for the code.

       

      Thanks and best regards,

      Helen Wang