YTD Calculation

[#1]

H all,

i want to calculate a YTD of year that i select.

For example if i select 2016-02 i want a sum of value of 2016-01 and 2016-02 etc...

Like field I have year_month (eg. YYYY-MM)

Can somebody help me?

[agni_gold]

Somethingh like that ?

[satishkurra]

Apology guys. I should have thought about this before replying...

[sunny_talwar]

No apology needed my friend... Thats how we all learn, isn't it?

[satishkurra]

Hmm yes

[#6]

Hi Sunny, with the field Year_Month doesn’t work, could be this because I don’t have a date YYYY-MM-DD or I’m wronging the formula?

Help me please ☹

[agni_gold]

elaborate please          

[sunny_talwar]

What exactly are you trying to get?

[#9]

I want YTD of Prior and Current year, but with the formula =RangeSum(Before(Sum({$}Qta)), 0, ColumnNo()))

I don’t’ think it is wrong…..

[sunny_talwar · Accepted solution]

This?

Current

=RangeSum(Before(Sum({$<ReportYearMonth={">=$(=YearStart(Max(ReportYearMonth)))<=$(=Max(ReportYearMonth))"}, Flag = {'CY'}>}Qta), 0, ColumnNo()))

Previous

=RangeSum(Before(Sum({$<ReportYearMonth={">=$(=YearStart(Max(ReportYearMonth)))<=$(=Max(ReportYearMonth))"}, Flag = {'PY'}>}Qta), 0, ColumnNo()))

[#11]

Hi Sunny,

now works!!!!!!! ☺ thanks thanks thank !