6 Replies Latest reply on Jul 13, 2018 3:33 PM by Helen Wang

    How to pull data from 'Current Quarter -1' (which is previous quarter)

    Helen Wang

      Hi all,

       

      Below the formula can pull Quarter to Date data for me:

      IF  YEAR([Fiscal Quarter])= 2018

      AND DATEPART('quarter',[Fiscal Quarter]) <=YEAR(TODAY())

      THEN [Ship + Cust Open Orders CRD]

      END

       

      But when I want to pull data from the "Current Quarter -1", which is equal to the previous quarter, I use

       

      IF  YEAR([Fiscal Quarter])= 2018

      AND DATEPART('quarter',[Fiscal Quarter]) <=YEAR(TODAY())-1

      THEN [Ship + Cust Open Orders CRD]

      END

       

      The result is wrong. Could you please advise?

       

       

      I would love any advice on the code. Thank you!