Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Max(FiscalYear)-1 is enough
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.
Thanks for replying,
I already used max(FiscalYear)-1. i am getting below output.
There is some issue with you data.
Max(FiscalYear)-1 do work
Then your field FiscalYear is not a year, it is a date field.
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
Your expression is working correctly. You just need to adjust the formatting.
m w wrote:
Your expression is working correctly. You just need to adjust the formatting.
Which one?
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??