Previoues Year value showing wrong

[Rajesh]

Hi All,

I am trying to display current yr & previous value in Text object like below with current yr Selection(2018) value is correct but 2017 value not correct.

With 2017 Year selection its showing correct value=648

Text object expression is :

=Max(Year) & ': ' & Num(Count({<Year=, Quarter=, Month=, DateType={'Opened'},Incident_problem= {'Problem'}, Date={">=$(=YearStart(Max(Date))) <=$(=Max(Date))"}>}number), '#,##0')

& Chr(10) & (Max(Year)-1) & ': ' & Num(Count({<Year=, Quarter=, Month=, DateType={'Opened'},Incident_problem= {'Problem'}, Date={">=$(=YearStart(AddYears(Max(Date), -1))) <=$(=AddYears(Max(Date), -1))"}>}number), '#,##0')

Can any one suggest where i am doing wrong.

Thanks

Rajesh

[sunny_talwar · Accepted solution]

May be try this

=Max(Year) & ': ' & Num(Count({<Year=, Quarter=, Month=, DateType={'Opened'},Incident_problem= {'Problem'}, Date={">=$(=YearStart(Max(Date))) <=$(=Max(Date))"}>}number), '#,##0')

& Chr(10) & (Max(Year)-1) & ': ' & Num(Count({<Year=, Quarter=, Month=, DateType={'Opened'},Incident_problem= {'Problem'}, Date={">=$(=YearStart(AddYears(Max(Date), -1)))<$(=YearStart(Max(Date)))"}>}number), '#,##0')

[Rajesh]

Thanks bro..

its working

[Rajesh]

Hi Sunny,

In which scenario we should write this

Date={">=$(=YearStart(AddYears(Max(Date), -1))) <=$(=AddYears(Max(Date),-1))"}

[sunny_talwar]

If you want to show YTD previous year....