One issue would be that for the 3 labels above (2011/12, 2012/13, 2013/14) I've have to do
- =$(=Reporting_Year-3) & '/' & right($(Reporting_Year-2), 2)
- =$(=Reporting_Year-2) & '/' & right($(Reporting_Year-1), 2)
- =$(=Reporting_Year-1) & '/' & right($(Reporting_Year), 2)
I was hoping something like lookup(fieldname, matchfieldname, matchfieldvalue [, tablename]) which I saw in inter record functions could be used but I don't seem to have it as an option. Guessing it is only available in Script load.