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]





      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.