Hello,

I am trying to get "14" out of fiscal year 2015-, 15 out of fiscal year 2016-, etc.
I can easily get "15" out of fiscal year 2015-, but making it 14 is proving difficult.
I am using Calculated Columns.
Any help with formulas is appreciated. Thank you in advance.

Are you working with transaction dates? If your fiscal year does not mirror the calendar year, GridView knows about your Fiscal Calendar.

Check out the help text for DATESTART(), DATEEND(), DATEIN() and INCLUDEAMOUNT() functions.

To get the (4 digit) year of the current fiscal period use:

where "M" is the current period (month) and "F" tells GridView to use the fiscal calendar. The DATESTRING() function returns just the 4 digit year. To return the 2 digit year, substitute "%y" for "%Y".

Thank you for your response. I need to ignore transaction date and translate each transaction by fiscal year. I will check out DATEIN().

You need:

Thank you very much!