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

    Previous Year's Quarter

    Baarathi V

      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))