4 Replies Latest reply on Mar 25, 2016 3:40 PM by Ercan Kaynakca

    How to extract fiscal quarter from calendar date?

    Ercan Kaynakca



      I am trying to get results since last fiscal quarter to current date but it doesn't work. How can I do that? I tried IIF([Clndr Dt] >= MAX([Fiscal Qtr Start Dt]), [Abandon Rate], 0) but I cannot mix aggregate with non aggregate. I tried IIF([Clndr Dt] >= DATETRUNC('quarter',[Fiscal Qtr Start Dt]), [Abandon Rate], 0) but DATETRUNC function give January instead of February. I also tried changing the default properties to fiscal year starting on August for [Clndr Dt] and extract the quarter and still gave me January first 2016.