10 Replies Latest reply: Aug 14, 2018 6:34 AM by surya j RSS

    Last Year QTD

    surya j



      I am using the below QTD formula for the Last Financial Quarter. When i filter out for the different quarter it has to show the respective last quarter data. But its not showing right . Logically for the current fiscal quarter i have almost 2 months data so even for the prior QTD it has to take only 2 months like the current FY quarter. But its taking entire last quarter data.


      =SUM({< fiscal_quarter, Date ={">=$(=date(QuarterStart(Today(),-4))) <=$(=date(QuarterEnd(Today(),-4)))"}>}



      Fiscal Quarter Format : FY16'Q1

      Please help me fix this?


      Thanks in Advance