Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
Thanks bro..
its working
Hi Sunny,
In which scenario we should write this
Date={">=$(=YearStart(AddYears(Max(Date), -1))) <=$(=AddYears(Max(Date),-1))"}
If you want to show YTD previous year....