7 Replies Latest reply: Sep 4, 2014 3:02 AM by jagan mohan rao appala RSS

    How I get the formula YearToEnd

      Hello together,


      I Need your help for a formula


      Now is June and I Need the formula from 7-12 dynamiclly. I transform the YTD to a YTE Formual. But it Shows the wrong values.

      My YTE formula is


      Sum({$<Nature={'Estimate 0'}, [Fiscal Year]=, month=, DateNum={">=$(=Max(DateNum)+1)<=$(=Num(YearEnd(Max(DateNum)))))"}>}Amount)


      Do you have a solution?