2 Replies Latest reply: Sep 10, 2018 10:38 AM by Andrea Gigliotti

# Previous Year's Quarter

I have tried the below expression to calculate Previous Year's quarter of current selected quarter. I have select the current quarter Oct-Dec 2017 in filter. I could not get the previous year's quarter Oct-Dec 2016?

= If(IsNull(GetCurrentSelections()) or (QuarterEnd(Max(TransactionDate)) = QuarterEnd(Today()))

, Sum({<TransactionDate  = {">=\$(=(Date(QuarterStart(Max(TransactionDate ),-5),'YYYY-MM-DD'))) <=\$(=(Date(QuarterEnd(Max(TransactionDate ),-5),'YYYY-MM-DD')))"} >}BilledAmount)

, Sum({<TransactionDate  = {">=\$(=(Date(QuarterStart(Max(TransactionDate ),-4),'YYYY-MM-DD'))) <=\$(=(Date(QuarterEnd(Max(TransactionDate ),-4),'YYYY-MM-DD')))"}>} BilledAmount))

• ###### Re: Previous Year's Quarter

Hey stalwar1

can you help me out with this?

Thanks and Regards

Baarathi

• ###### Re: Previous Year's Quarter

maybe this:

Sum( {< TransactionDate = {">=\$(=QuarterStart(Max(TransactionDate),-4))<=\$(=QuarterEnd(Max(TransactionDate),-4))"} >} BilledAmount )

I hope it helps.