header expression

[rcorcoran]

Hi Trying to get a header to show the current year selected -1 ie 2015 if it is 2016 selected.  Any help would be appreciated

='Staff Category Primary Care '& GetFieldSelections((ReferredYYYY)-1)

[sunny_talwar · Accepted solution]

Try this:

='Staff Category Primary Care '& (GetFieldSelections(ReferredYYYY)-1)

or may be this:

='Staff Category Primary Care '& (Max(ReferredYYYY)-1)

[rcorcoran]

Thanks Sunny works a treat