10 Replies Latest reply: Sep 3, 2014 10:08 AM by Manish Kachhia RSS

    YTD from previous year

      Hello togehter,

       

      I have a YTD Formula (it Shows the right figures)

       

      Sum({$<Nature={'Actual'},[Fiscal Year]=, month=, DateNum={">=$(Num(YearStart(Max(DateNum))))<=$(=(Max(DateNum)))"}>} Amount)

       

      this formula Shows the wrong figures

       

      Sum({$<Nature={'Actual},[Fiscal Year]=, month=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))>=$(=AddYear(max(DateNum), -1 ))"}>}Amount)

       

      Do you know why? and could help me.

       

      Thanks