3 Replies Latest reply on May 5, 2016 6:34 AM by Stephane Marx

    How to get sum values for current fiscal quarter and fiscal year?

    Yerram Reddy

      Hi All,

       

      I am trying to get the sum sales for current fiscal quarter my fiscal year starts in November, I am trying to get this in calculated field.

      I am not using any date field in sheet.

       

      I am trying  like this

      IF DATEPART('quarter',[Order Date])= DATEPART('quarter',TODAY())

      and YEAR([Order Date])=YEAR(TODAY()) THEN [Sales] END

       

      this calculation is taking default quarter not fiscal quarter. same for fiscal year also.

      Please help me on this.

      Thanks in advance