Display last 3 years in a textbox and ignore selections in list boxes

[#1]

Hi,

I have 3 text boxes objects that contains 3 expressions to display the Year of the last 3 years, however i don't want it to be affected by the selections in the Date list boxes.

Text box 1

='FY '&$(=max(Year-2))

Text box 2

='FY '&$(=max(Year-1))

Text box 3

='FY '&$(=max(Year))

How can I fix the values to be ignored by the selections in the list boxes?

Thanks in advance for your help

Cheers,

Paulo

[sunny_talwar · Accepted solution]

Try this:

Text box 1

='FY '& (Max({1}Year)-2)

Text box 2

='FY '& (Max({1}Year)-1)

Text box 3

='FY '& (Max({1}Year))