Issue in finding previous year in kpi

[jayaseelan]

Hi everyone,

         I have following fiscal years 2013,2014,2015,2016, i am trying to show the max of fiscal year in KPI its working fine.

and i am trying to  show previous year to the max in KPI is not working. my output screen shot is below. 

[jonathandienst]

>>While finding max of Fiscal year there is no problem in format, why issue in previousyear??

Good question. I only noticed that now that you have asked. But its hard to say without looking closely at your model. Perhaps you have a mix of years and dates in that field.