Show only bottom 8 years in list box...

[#1]

Hi All...

I have a list box with 11 years... but i have to show only bottom 8years every time (in this scenario from 2005 to 2012)... How can i achieve this

2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005

Thanks...

[pauljohansson]

Hi,

It is possible to create a Listbox on an expression. So you can select an expression, in your case,

=if (years>2004, years, )

instead of selecting the concerned field,

br

Paul

[Marc_Kaiser]

=if (years>2004, years, )

=if(years <= (vMinYear+7), years)

-> Now, only 8 years will be displayed, i.e. 2013, 2014, 2015 will be excluded.

If min year can very, create a variable that consists of the required min year:

=if(years <= (vMinYear+7), years)

Marc