4 Replies Latest reply: Sep 16, 2017 8:38 AM by Mukesh Rathod RSS

    Previous Fiscal Year YTD

    Mukesh Rathod

      Hi,

       

      I have a requirement where i want to show values for fiscal Year YTD and LYTD.

      Selecetion Available is only calendar Year.

      So for Eg:

      MY Fiscal YTD value i.e from Mar2017 to 14Sept2017 is 100.

      Then my Previous Year value should also show for period Mar2016 to 14Sept2016.


      Now if I'm selecting 2016 then my current period value should show from mar2016 to feb2017.

      and for previous period it should from mar2015 to feb2016.


      so i'm writing my expression as

      Sum({<FiscalYear=,Date={"<=$(=Addmonths(YearStart(Max(Date),0,3),-12))<=$(=Yearend(Addmonths(Max(Date),-12),0,3))"}>}Sales)

      Then it will show value for Mar2016 to feb2017,but i want to show value till currentdate.


      Please help