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

    Last Year QTD

    surya j

      Hi

       

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

      accessories_revenue)

       

      Fiscal Quarter Format : FY16'Q1


      Please help me fix this?

       

      Thanks in Advance