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.