7 Replies Latest reply on Jul 16, 2018 11:03 AM by Helen Wang

    Why my formula is not pulling any data?

    Helen Wang

      Hi all,

       

      I want to pull the data from Q1, 2019.

       

      I have written code like this:

       

      ZN(IF str(DATEPART('year',[Fiscal Quarter] ))= '2019' AND str(DATEPART('quarter',[Fiscal Quarter] )) ='1'

      THEN [$ Ship Final Act-Fcst]

      END)

       

       

       

      This code works for Q1 2018, Q2 2018, Q3 2018 and Q4 2018. But I only get 0 for Q1 2019.

       

      There is data for Q1 2019. I just cannot pull it with this code...

       

       

      Please help!!!

       

       

      I cannot attach the data. I would love any advice on code.

       

      Thanks,

      Helen