2 Replies Latest reply on Jul 6, 2017 10:29 AM by Shinichiro Murakami

    Help Converting Calendar Year Calcs into Fiscal Year Calcs

    Kevin Warren

      Hello,

       

      I am having trouble identifying current fiscal year months within a calculation.

       

      How can I re-create this calculation using Fiscal Year starting at 7/1?

       

      YTD Current Year Only FINAL:

      If

      DATEPART('year',[Date])=datepart('year',[Max Date]) and

      [Date] <= [Max Date]

      THEN [Final Net Back % to display]

      END

       

      Please see workbook for some context and eventual desired output at aggregated level.

       

      Thank you!