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

    Fix required in QTD formula

    surya j



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



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