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. 

[robert_mika]

Max(FiscalYear)-1 is enough

[rubenmarin]

Hi, Max(FiscalYear)-1 will return the previous year. You don't need the Year() funtion, as this function expects a date to return the year of the date.

[jayaseelan]

Thanks for replying,

                I already used max(FiscalYear)-1. i am getting below output.

[#5]

There is some issue with you data.

Max(FiscalYear)-1 do work

[jonathandienst]

Then your field FiscalYear is not a year, it is a date field.

[jonathandienst]

I would prefer to understand why have a field called xxxYear, which contains a date rather than a year value, but you can work around that with

     =Max(Year(FiscalYear)) - 1

[m_woolf]

Your expression is working correctly. You just need to adjust the formatting.

[jonathandienst]

m w wrote:

Your expression is working correctly. You just need to adjust the formatting.

Which one?

[jayaseelan]

Thanks Jonathan,

Its working. i changed the format to previous year.  but i have an doubt,

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