21 Replies Latest reply: Aug 15, 2018 1:09 PM by Sunny Talwar RSS

    Fix required in QTD formula

    surya j

      Hi

       

      I have a Fiscal Quarter in FY18'Q4 format. I am using the below formula to calculate the dynamic QTD.


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

      accessories_revenue)

       

      For ex while selecting FY18'Q4 it has to show the QTD data for FY17'Q4. But its not giving this output

       

      Please help me to resolve this

       

      Thanks in advance!!!