Show only certain values in a list box

[scotthan]

Hi, I am trying to show only values in FieldA with the most recent Load Date. I can use an expression like =if(LoadDate=vMaxLoadDate,FieldA) but that's no good because when you make a selection, LoadDate pops up in your current selections box.

I was using field triggers and a hidden field to try to solve this, but the client noticed that the back button doesn't work properly when I created that. (You had to hit the back button multiple times to go back.)

Any ideas? Thanks.

[whiteline · Accepted solution]

Hi.

This should do the trick:

=aggr(if(LoadDate=vMaxLoadDate,FieldA),  FieldA)