How I get the formula YearToEnd

[#1]

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

[MK_QSL]

=SUM({<

     Nature={'Estimate 0'},

     [Fiscal Year]=,

     month=,

     DateNum= {'>=$(=NUM(Today()))<=$(=NUM(YearEnd(Today())))'}>}Amount)

[#3]

Thank you for this formula

But for the first NUM(Today()) i Need the current Month +1 (e.g. Juni +1 = Juli), it should be dynamically which month is selected.

(Num(YearEnd(today())) here I Need the dynamically the year which is selected (e.g. the current year 2014, it should Show to the End of the year 2014.

Do you have a solution for me.

Thanks

[tresesco]

May be like:

NUM(AddMonths(Today(),1))    // to get next month

[jagan]

Hi,

Try like this

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

Regards,

jagan.

[#6]

Hello,

is the formula Today() and the selected month the same like May(DateNum)?

[jagan · Accepted solution]

Hi,

Missed Num() to convert date to number.

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

Regards,

Jagan.

[jagan]

Hi,

Today() will give current date (Today - 4th September)

Max(DateNum) - will give the max date in the date field for the current selections.

Regards,

Jagan.