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?

       

      Thanks