Customized List Box

[azmeerrehan]

In my data set I have Years  like 2018,2017,2016, etc.  I dont want to limit the script for 2018, but on the list box I would like to see only Current  and 3 Prev years, how can I do that ?

[Anil_Babu_Samineni]

One best solution this for expression in list box rather direct field

If(Year <> 2018, Year)

[Kushal_Chawda]

=aggr(if(YearField>= year(addyears(today().-3)) and YearField<= year(today()), YearField),YearField)

[suryaa30]

Create below variables:

vNow: Date(max(TOTAL DateYearField))

vPrev3: $(vNow)-AddYears($(vNow),-3)

Then in list box use below condition. in drop down select expression at the bottom most.

=if(($(vNow) - DateYearField))>0) and ($(vNow) - DateYearField))<= $(vPrev3)),DateYearField)

[antoniotiman · Accepted solution]

Maybe

=IF(Year >= Year(Now())-3 and Year <= Year(Now()),Year)

[azmeerrehan]

Syntax does not look right

[Kushal_Chawda]

Or try this

AGGR(If(YEAR>= year(today()) - 3 and YEAR <=year( today()), YEAR), YEAR)

[passionate]

Simple way to do this is using calculated expression in listbox:

=Valuelist(Year(Today()),Year(Today())-1,Year(Today())-2,Year(Today())-3)