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



      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:


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

      [Date] <= [Max Date]

      THEN [Final Net Back % to display]



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


      Thank you!