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)

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

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

• ###### 1. Re: How to pull data from 'Current Quarter -1' (which is previous quarter)

Is it CORRECT? What is this returning???

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

• ###### 2. Re: How to pull data from 'Current Quarter -1' (which is previous quarter)

It can return the data of the current quarter.

It is for a calculation for quarter to date, where I calculate the sum of all the numbers in this quarter

• ###### 3. Re: How to pull data from 'Current Quarter -1' (which is previous quarter)

See if this helps.

Here are the formulas am using:

• ###### 4. Re: How to pull data from 'Current Quarter -1' (which is previous quarter)

Happy Friday Hari! I have 1 question: Could you please give me some advice when you get a chance?

Thanks!
Helen

• ###### 5. Re: How to pull data from 'Current Quarter -1' (which is previous quarter)

It looks like you have already been helped.

• ###### 6. Re: How to pull data from 'Current Quarter -1' (which is previous quarter)

Hi Hari,

if you have a minute, could you please give me some advice on:

Thanks,

Helen